Add custom data source to visual studio 2015

Question

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

So i have used nuget to install:

• entityFramework
• npgsql
• npgsql.entityFramework

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
   4. Select "EF designer from database" and click next
   5. Click new connection button Add i get the window "Choose data source"

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

Answer 1

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