CODEWITHSUNDEEP
asp.netpostgresqlado.net-entity-data-model
Harsha
Harsha

Reputation: 1181

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 working fine.

Now, we want to use PostgreSQL which is open source, so is it possible to change the database from Sql server 2008 to PostgreSQL.

I checked devart and npgsql to implement the connectivity to postgresql database using entity data model.

When I checked devart, it supports entity data model in professional edition (which is licensed). And we dont want to use any licensed components.

When I checked npgsql, there are no examples or links which explain about connecting to postgresql using ado.net entity framework.

Now my question is, is it possible to implement postgresql, ado.net entity model, linq ???

Upvotes: 2

Views: 2387

Answers (1)

Michele Lepri
Michele Lepri

Reputation: 440

Few months ago I worked on a project using postgresql, npgsql, EF and linq: so yes, is possible, but required a bit of work to set up it.

On http://npgsql.com/ there are few articles on how to handle it, but now the web site seem to have some mapping problems with the pages :) So I link to you the google cached ones:

Part1

Part2

Upvotes: 2

Related Questions