Npgsql.EntityFramework EF6 and ADO.NET Entity Data Model
don...@gmx.com
When I get to the step: Change Data Source, only the SQL Server providers appear in the list. (PostgreSQL Database) does not show up.
What troubleshooting steps can I perform to figure out why it's not showing up?
Win7 x64, VS2013 Pro
h8ma...@gmail.com
I think there are 3 main parts to be checked:
---
(1) Npgsql GAC installation and machine.config
I have written checker program. Please try it.
Check README at CheckNpgsqlSetupStatus
https://github.com/kenjiuno/CheckNpgsqlSetupStatus/
---
(2) VSIX installation.
If you have problem to build vsix, try my binary:
NpgsqlDdexProvider.vsix
https://drive.google.com/file/d/0BzIsP2o582nbWUlQYWlLMlpJS3c/edit?usp=sharing
---
(3) VS2013 Project.
I have a configured project ready to use with Npgsql+EF6.
testef.zip
https://drive.google.com/file/d/0BzIsP2o582nbTjFKYnlMV1U0eUU/edit?usp=sharing
Check if you can select PostgreSQL Database from new EDM file wizard.
---
thanks
kenji uno
don...@gmx.com
Your testef project worked, so I went back into my original project and compared the two and they matched up so I compared the references and they were also the same. So as most crazy programmers do, I built the project and tried again even though nothing changed...it worked!
So...What I think happened is, when I first discovered the problem, I went back through the setup line by line, uninstalling and reinstalling and ended up finding that the reference to npgsql.entityframework was missing, so I added it...but it still didn't work. I think the step that I missed was "BUILD the project" after adding the framework reference.
Thanks for the help! Now, I need to really delve into the code and figure out how to get Non-Updatable Views to come across...
emil.l...@gmail.com
Sometimes you also need to rebuild your project once before PostgreSQL appears.