UPDATE2: For some reason, Blogger lost the original post. I had to republish it.
UPDATE: Jerónimo told me that you must use the Npgsql version which is inside the zip file in order to make it work.
After so much time (more than I wanted it to take) Npgsql finally has a initial design time support for Visual Studio!
This work was done by Jerónimo Milea. Jerónimo let me know he was working on DDEX support on this thread after I said I was working on DDEX support for Npgsql.
He sent me his working copy and I started to play with it. Note that as a preview version many things may not work ok and we wanted you to provide us feedback so we can fix any bugs.
You can download the project file from our downloads page.
Design time support is provided as a zip file containing support code as well as a copy of Npgsql project file. So, everything you need to start working with design time support is already packaged for you.
When you unzip the file, you will have three folders and a project file. Open up this project file in Visual Studio 2010.
There are three projects. The Npgsql.Provider project is there for historical reasons, Jerónimo told me. We will clean it up in another release. The main project is the Npgsql.Provider2. Set it up as your startup project. Right Click -> Set up as Startup Project.
After that, tell Visual Studio to build all projects. After everything is compiled ok, there are still some other steps to be done:
<add name="Npgsql Data Provider" invariant="Npgsql" support="FF" description=".Net Framework Data Provider for Postgresql Server" type="Npgsql.NpgsqlFactory, Npgsql, Version=2.0.11.91, Culture=neutral, PublicKeyToken=5d8b90d52f46fda7" />
Playing with Design Time support project
As this project will work inside VS.Net, you will need to debug VS.Net itself in order to have the project running inside it. In order to do that, you have to specify VS.net as the debug target. To do that, open Npgsql.Designer2 project properties and in the Debug tab, check the value of "Start external program" edit text. It is set to the path of devenv.exe. Note that it is the path of (x86) Program Files folder. This is ok if you are using a 64-bits windows installation. If you are using a 32-bits install (as I do), you just have to remove the (x86) from the path and you are set.
After setting everything up, you can hit F5 to start the project ( you specified Npgsql.Designer2 as your startup project, right?). A new VS.Net will show up and your first VS.Net will be attached to it in debug mode. Now, comes a very important step you have to make: Inside Npgsql.Designer2 folder, there is a file called NpgsqlProvider.gen.reg. You have to merge this file to your registry every time you start VS.Net to debug the project. This is needed because VS.Net as it is started by the project, has a command line option which makes it use an alternate registry tree which is cleaned up every time this VS.net is started. This reg file has the settings to register Npgsql.Designer inside VS.Net.
That's it! If everything is ok, you may now create a new project or open an existing one and add a new datasource to it using Postgresql as the backend! This procedure is somewhat complex, but after it is done once, you only have to repeat the merge registry file part.
Please, let me know if you have any problems setting this up. Also, please, send your comments and bug reports to our bug tracker: bugs.npgsql.org
Again, thanks Jerónimo for all his help and for this excellent work.
UPDATE: Jerónimo told me that you must use the Npgsql version which is inside the zip file in order to make it work.
After so much time (more than I wanted it to take) Npgsql finally has a initial design time support for Visual Studio!
This work was done by Jerónimo Milea. Jerónimo let me know he was working on DDEX support on this thread after I said I was working on DDEX support for Npgsql.
He sent me his working copy and I started to play with it. Note that as a preview version many things may not work ok and we wanted you to provide us feedback so we can fix any bugs.
You can download the project file from our downloads page.
Design time support is provided as a zip file containing support code as well as a copy of Npgsql project file. So, everything you need to start working with design time support is already packaged for you.
When you unzip the file, you will have three folders and a project file. Open up this project file in Visual Studio 2010.
There are three projects. The Npgsql.Provider project is there for historical reasons, Jerónimo told me. We will clean it up in another release. The main project is the Npgsql.Provider2. Set it up as your startup project. Right Click -> Set up as Startup Project.
After that, tell Visual Studio to build all projects. After everything is compiled ok, there are still some other steps to be done:
- Install Npgsql.dll and Mono.Security.dll to GAC.
- Add Npgsql as a provider factory in machine.config
Install Npgsql.dll and Mono.Security.dll to GAC
Go to the Npgsql2\bin\debug4\ folder and add Npgsql.dll and Mono.Security.dll to GAC:
gacutil -i Npgsql.dll
gacutil -i Mono.Security.dll
gacutil -i Mono.Security.dll
Note that you will need to start a Visual Studio Command Prompt so command line tools are available to you. This shortcut is inside Visual Studio 2010 programs folder in the Visual Studio Tools subfolder.
Add Npgsql as a provider factory in machine.config
In the machine.config file, located at C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config you have to add following line:
<add name="Npgsql Data Provider" invariant="Npgsql" support="FF" description=".Net Framework Data Provider for Postgresql Server" type="Npgsql.NpgsqlFactory, Npgsql, Version=2.0.11.91, Culture=neutral, PublicKeyToken=5d8b90d52f46fda7" />
This line goes inside the DbProviderFactories section.
Playing with Design Time support project
After config Npgsql in gac and machine.config, it's time to run the project.
As this project will work inside VS.Net, you will need to debug VS.Net itself in order to have the project running inside it. In order to do that, you have to specify VS.net as the debug target. To do that, open Npgsql.Designer2 project properties and in the Debug tab, check the value of "Start external program" edit text. It is set to the path of devenv.exe. Note that it is the path of (x86) Program Files folder. This is ok if you are using a 64-bits windows installation. If you are using a 32-bits install (as I do), you just have to remove the (x86) from the path and you are set.
After setting everything up, you can hit F5 to start the project ( you specified Npgsql.Designer2 as your startup project, right?). A new VS.Net will show up and your first VS.Net will be attached to it in debug mode. Now, comes a very important step you have to make: Inside Npgsql.Designer2 folder, there is a file called NpgsqlProvider.gen.reg. You have to merge this file to your registry every time you start VS.Net to debug the project. This is needed because VS.Net as it is started by the project, has a command line option which makes it use an alternate registry tree which is cleaned up every time this VS.net is started. This reg file has the settings to register Npgsql.Designer inside VS.Net.
That's it! If everything is ok, you may now create a new project or open an existing one and add a new datasource to it using Postgresql as the backend! This procedure is somewhat complex, but after it is done once, you only have to repeat the merge registry file part.
Please, let me know if you have any problems setting this up. Also, please, send your comments and bug reports to our bug tracker: bugs.npgsql.org
Again, thanks Jerónimo for all his help and for this excellent work.
Comments
Then I've tryed to use edmgen.exe to generate DB model. but error apears:
error 7001: The specified store provider 'Npgsql' cannot be found in the configuration, or 'Npgsql' is not valid.
Unable to find the requested .Net Framework Data Provider. It may not be installed.
Plese help. I would like to use Npgsql2 with Entity Framework
You said this "
When you unzip the file, you will have three folders and a project file. Open up this project file in Visual Studio 2010."
But when i unzip the file there is only 3 folders.....and no project file :(
Where is this project???
Also, I have a second question: Why the designer shows a warning regarding unsupported "money" type?
why dont you put it on github, much better for collab... ?
two things: first thing I couldn't find the project file, and after I created my own solution, I was not able to find the folder Npgsql.Designer2 and the file NpgsqlProvider.gen.reg. Could you check the zip file once again and make sure?
Secondly, I'd like to know what differences it has compared to Devart's driver?
Thanks.
two thing: first one is some files seems to be missing in the download. I couldn't find the project file, and could not find the folder Npgsql.Designer2 and file NpgsqlProvider.gen.reg after I build the project from my own solution.
Secondly, what differences does Npgsql have compared to Devart's driver?
Regards.
About Devart's driver, I don't know very much about the differences as I didn't try it. I think one big missing feature of Npgsql today is vs.net design time support. I hope to get that fixed. Sorry for not having too much information about the differences.
Today we have a mirror in github. Check out: git.npgsql.org
I hope it helps.
Sorry for that. You should open the project inside Npgsql.Designer2 folder.
Sorry for all those problems.
The project which must be built is inside the Npgsql.Designer2 folder.
I hope to get more news soon.
i opened the solution Npgsql.Provider2 that´s inside the folder Npgsql.Provider2, and when I tried to build it didn´t built and showed me 98 erros, so I cant go on the process. What should I do? What´s is wrong?
I've downloaded your files but when I try to open solution files (VS2008 or VS2010) I found a different Project tree and of course it doesn't work. Do you have idea of a working release date ?
Thank you
Gianpy
Do you have idea of a Visual Studio working release date ?
Thank you
Gianpy
Why can't you just post prebuilded assemblies?
I was just wondering whether you have any update on the new NpgSql version, the one with the DDEX support...
Thanks in advance for letting us know!
Cheers,
Gianluca
Npgsql.Designer2 folder isn't there in any .zip downloaded, any other project rebuild generate a lot of error and missing dependencies.
We will wait for better release,thanks
I've problem exactly the same as you, because, maybe, of use VS 2010 express?
I've problem exactly the same as you, because, maybe, of use VS 2010 express?
I just download the ZIP file of the project, but no "NpgsqlProvider.gen.reg" file in this. and no folder "Npgsql.Designer2" too?
Thank you.
Is there any known issue about this message?
"Could not get column information to database object...."
Fired when try to drag&drop table from server explorer into the dataset. VS2010Pro
Everything works fine, except d&d action.
I have an application in VS2010 which uses npgsql.
If I switch on my application from VS or manually from debug (where I have mono and npgsql) it works.
But if I move my .exe to another place e.g. d:/ or pendrive or another computer my application turns on but if try connect to data base application disapear.
How to link .dll files with .exe?
You should put Npgsql.dll and Mono.Security.dll in the same folder of your .exe.
I hope it helps.
I've downloaded the .zip file and when I open the project file "Npgsql.Provider2.csproj" in VS 2010 shows "Npgsql.Provider2(não disponivel)".
Could you please help me?
Thanks
I'm trying to run this application with VS 2012 and was able to set it up by following the steps here. I got the new VS 2012 instance running but when I try to add a new ADO.NET Entity Model, I do not get to choose Npgsql for my new connection. Can you please help?
Thanks,
Abhi.
Thanks for the support!
I followed the steps and everything works fine but when I closed and reopen project, I can't connect to database any more.
How can I fix this error?
Thanks!
Signature:
download free descargar whatsapp plus and download baixar whatsapp plus online and descargar whatsapp , baixar whatsapp gratis