Posther interaction

Question

I know that there are many posts that asked this question, but this is a kind of problem that I am facing.
It seems that there are so many different ways to interact with postgres with C #, I don’t know which one is recommended, as many posts are outdated, and it seems that progress has been made in this area.

If possible, I would like to have linq support, and since this is a private project, it should be free.

Some of the features I found are:
Framework Entity (Npgsql)
It seems to have no linq support.

DBLinq, which uses Linq2SQL, not Linq2Entities.
Linq2SQL seems deprecated.

To ask a few questions:
Is it possible (using the currently available software) to set the settings so that I can use the code as shown here ?:
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 interact with Postgres?

Answer 1

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