I got excited when I randomly happened across Npgsql again this morning on Github.
Ok I may already have been excited considering I finally got round to watching the first dubbed episode of Attack on Titan but Npgsql is interesting as it solves one of my only problems with Entity Framework... having to use Microsoft SQL Server. Don't get me wrong sql servers management studio is the best database tool out there but PostgreSQL does a much better job at being a database (and it's usually cheaper to buy, something nice if your not someone sitting on Smaug's treasure pile).
But alas it seems that we still don't have a "code first" approach working with this framework even though its been nearly a year since I played with it. Its a shame but these guys work on this in there spare time and its all free so cant be angry at them.
Check it out at their Github page, database first approach still works perfectly fine.
Npgsql is a .Net Data Provider for Postgresql. It allows any program developed for .Net framework to access database server. It is implemented in 100% C# code. Works with Postgresql 7.x and above.