title: how to use postgresql with ado.net entity framework in asp.net mvc 2
body: <p>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.</p>
  
  <p>Now, we want to use PostgreSQL which is open source, so is it possible to change the database from Sql server 2008 to PostgreSQL.</p>
  
  <p>I checked <a href="http://www.devart.com/entitydeveloper/" rel="nofollow">devart</a> and <a href="http://pgfoundry.org/projects/npgsql/" rel="nofollow">npgsql</a> to implement the connectivity to postgresql database using entity data model.</p>
  
  <p>When I checked devart, it supports entity data model in professional edition (which is licensed). And we dont want to use any licensed components.</p>
  
  <p>When I checked npgsql, there are no examples or links which explain about connecting to postgresql using ado.net entity framework.</p>
  
  <p>Now my question is, is it possible to implement postgresql, ado.net entity model, linq ???</p>