Menu
I'm interested to find out which ORM has best support for Postgres SQL database? Does any mapper have, both, LINQ support and ability to generate model from database?
202
Geshan Manandhar on Jul 20, 2021. An Object Relational Mapper (ORM) is a code library that plots the transfer of data stored in a database (usually relational) into objects represented in the code.
Npgsql is an open source ADO.NET Data Provider for PostgreSQL, it allows programs written in C#, Visual Basic, F# to access the PostgreSQL database server. It is implemented in 100% C# code, is free and is open source.
Using the Entity Data ProviderdotConnect for PostgreSQL allows using it in Entity Framework models in various ways. You can use our provider with standard Visual Studio Entity Framework tools, in the same way as SqlClient.
I haven't compared it against DbLinq but LlbgenPro supports Postgres and is very strong. It supports both Linq and generating the model from the database. In it's just released v3.0 it can generate projects not just for the LlblGen runtime but also for NHibernate, Entity Framework and LinqToSql.
It should be in your list to evaluate.
172
Quite an old question, but for anyone happening upon this now (like me), please do check out the Marten document & event store for PostgreSQL/.net
29
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
