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:

Right click on the project in visual studio 2015
Add new item
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"

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

What happens when you select <other>

user330315
– user330315

2015-11-17 20:58:50 +00:00
Commented Nov 17, 2015 at 20:58 — user330315
– user330315, Commented Nov 17, 2015 at 20:58

mhd · Accepted Answer · 2016-01-14 17:22:25Z

2

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

answered Jan 14, 2016 at 17:22

mhd

4545 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

G. Goncharov · Accepted Answer · 2020-09-28 07:13:50Z

0

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.

answered Sep 28, 2020 at 7:13

G. Goncharov

3023 silver badges15 bronze badges

Collectives™ on Stack Overflow

Add custom data source to visual studio 2015

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related