Connecting ado.net Entity data model to postgresql database
NickName:user1815201 Ask DateTime:2013-06-21T19:33:40

Connecting ado.net Entity data model to postgresql database

I'm new to C#, ado.net and visual studio 2012, just to make that clear from the beginning.
I'm trying to connect an ADO.NET Entity Data Model to a postgresql database.
I tell VS to 'generate mdoel from database' and click to make a new connection. Postgresql is not listed as an alternative data source (I can only see different microsoft mysql sources). I did download the npsql .dlls and put them in the projects\ folder. I then added them by PROJECT->Add Reference->browse, check them and press ok.

Postgresql does still not appear as an alternative when I try to make a new connection.

In advance, thanks!

Copyright Notice:Content Author:「user1815201」,Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/17234241/connecting-ado-net-entity-data-model-to-postgresql-database

More about “Connecting ado.net Entity data model to postgresql database” related questions

Connecting ado.net Entity data model to postgresql database

I'm new to C#, ado.net and visual studio 2012, just to make that clear from the beginning. I'm trying to connect an ADO.NET Entity Data Model to a postgresql database. I tell VS to 'generate mdoel...

Show Detail

Connect ADO.NET Entity Data Model to Postgresql database

I'm creating an ASP MVC 3 website. I have a Postgresql database - I'm using Entity Framework 6 - I have referenced Npgsql and Npgsql.EntityFramework and installed dotConnect for PostgreSQL. The

Show Detail

how to use postgresql with ado.net entity framework in asp.net mvc 2

In my current project, we are using visual studio 2008, sql server 2008, mvc 2 with ado.net entity framework (ado.net entity data model), linq and developing a web application. This application wor...

Show Detail

MultipleActiveResultSets for postgresql and ado.net entity data model

Im using visual studio, postgresql database and ado.net entity data model. In the connectionstring, Im unable set MultipleActiveResultSets=True. Usually when I connect to sql server with

Show Detail

Does ADO.NET Entity Data Model update with live data ?

net-mvc website which will query an existing database on Azure (I have nothing to do with the database. I just have access to do read only queries.). I created an ADO.NET Entity Data Model connect...

Show Detail

Postgres Database not available in ADO.NET Entity Data Model

I am trying to create entities from a postgres database using the Visual Studio ADO.NET Entity Data Model, however Postgres Database is not listed as one of the data sources. I have installed dotc...

Show Detail

Unable to find Postgresql data source in Entity Data Model Wizard

I am stuck in the middle of a project. I am having an issue with adding the data source in "Entity Data Model Wizard" Navigation Path::::: Solution Explorer : Models(Folder): Add : New Item : AD...

Show Detail

ADO.NET Entity Data Model vs DataSet vs Entity Framework?

So I know there are few ways to access data from the database. I worked a bit with ADO.NET Entity Data Model, DataSet and Entity Framework. But still I can't quiet grasp what is what. I know the b...

Show Detail

Connecting ADO.Net entity data model to database

I have a WPF application using an ADO.NET entity data model. After creating the edmx, a connection string is by default created in app.config like this: <add name="Entities" connectionStr...

Show Detail

postgresql does not appear in Data Source when generating .ADO.net Entity Data Model

I succeeded in accessing an existing postgresql dbase by using npgsql directly. I used for this: PostgreSQL 9.0.10 (32 bit) Visual Studio 2015 Community (64 bit) NpgSql 2.2.5 (through Manage

Show Detail