Postgres interaction [closed]

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. Closed 11 years ago.

I know there are many posts which asked that question, but this is kind of the problem I'm having.

There seems to be so many different ways to interf开发者_开发技巧ace with postgres with C# I don't know which is the current recommended way, since many posts are dated and it looks like progress was made in that area.

If possible I'd like to have linq support and since this is a private project it has to be free.

Some of the possibilities I found:

Framework Entity (Npgsql)

Which does not seem to have linq support.

DBLinq which uses Linq2SQL and not Linq2Entities.

Linq2SQL seems to be deprecated.

So to ask some questions:

Is it possible (with currently available software) to set things up so I can use code like shown there?:

http://msdn.microsoft.com/en-us/library/cc161164.aspx#_Toc188851309

using (NorthwindEntities nw = new NorthwindEntities()) 
{ 
    var customers = from c in nw.Customers where c.City == "London" select c; 
}

If not, what is the current recommended way to interface with Postgres?

---

If you want to use code like the one you showed (things like LINQ + PLINQ + EF V 1 + EF V 4 + ADO.NET etc.) and a commercial library is an option then I would recommend http://www.devart.com/dotconnect/postgresql/ - not affiliated, just a happy customer...