CODEWITHSUNDEEP
entity-frameworkpostgresqlvisual-studio-2015
mhd
mhd

Reputation: 444

Add custom data source to visual studio 2015

I want to use Entity Framework 6 to connect to PostgreSql database using Visual Studio 2015 (Entreprise).

So i have used nuget to install:

Then i have modified the app.config like below:

<system.data>
    <DbProviderFactories>
      <clear />
      <add name="Npgsql Data Provider" invariant="Npgsql" description=".Net Framework Data Provider for Postgresql Server" type="Npgsql.NpgsqlFactory, Npgsql, Version=2.2.5, Culture=neutral, PublicKeyToken=5d8b90d52f46fda7" />
    </DbProviderFactories>
  </system.data>
<entityFramework>
    <providers>
      <provider invariantName="Npgsql" type="Npgsql.NpgsqlServices, Npgsql.EntityFramework" />
    </providers>
   <defaultConnectionFactory type="Npgsql.NpgsqlConnectionFactory, Npgsql" />
  </entityFramework>

After that, i have tried to generate the edmx file of PostgreSql database:

  1. Right click on the project in visual studio 2015
  2. Add new item
  3. Select "ADO.Net entity data model" object under "data" tab and "Entity Data Model Wizard" is there
    1. Select "EF designer from database" and click next
    2. Click new connection button Add i get the window "Choose data source" enter image description here

As you can see in the picture, there's no data source for PostgreSql. Is there something to set up with visual studio 2015?

Upvotes: 3

Views: 5495

Answers (2)

G. Goncharov
G. Goncharov

Reputation: 302

For me didn't help to add such strings in app.config (even relaunch VS many times), but helped to recreate project after installed "Npgsql PostgreSQL Integration Visual Studio", the same lines were added to app.config automatically.

Upvotes: 0

mhd
mhd

Reputation: 444

The thing is i should setup Visual Studio 2015 the first time to support npgsql. The full setup is here http://www.npgsql.org/doc/ddex.html May be the link could help someone else

Upvotes: 2

Related Questions