linq - Cannot create a model from a preexisting database in Postgresql, .NET provider for postgresql doesn't exist -
i'm having problem that's blocking me on 4 days now. i'm developing wcf webservice , tried connecting postgresql database via visual studio 2010. installed npgsql, entityframework, linqtopostgresql, , devart dotconnect postgresql, shaolinq... nugetpackage manager. installed entity developer.
i managed create connexion postgresql database, when try create model out of database (i add new devart linq sql model item), postgresql provider doesn't show in combobox! here screenshots more clarification :
here in provider combobox 3 choices :
.net framework data provider microsoft sql server compact 3.5
.net framework data provider microsoft sql server compact 4.0
.net framework data provider sql server
here's screenshot references added project :
thanks in advance help!
the work-around managed apply moment using npgsqlcommand directly code , connecting database. can't use database entities classes @ least trick, now. still hope enlighten me more issue 'cause seems there no solution frustrating. literally on edge of starting scratch , re-creating spatial database in sql server.