Junior
What ORM systems have you worked with?
sobes.tech AI
Answer from AI
I have worked with the following ORM systems in C:
- Entity Framework (EF) and Entity Framework Core (EF Core) — the most widely used ORM in the .NET ecosystem. They have powerful features, support LINQ, migrations, and a wide range of database support. EF Core is a more modern and performant option.
- Dapper — a micro-ORM focused on performance and flexibility. It provides extension methods for the IDbConnection type, allowing direct execution of SQL queries and retrieval of results into strongly typed objects. Dapper does not offer change tracking or schema generation.
- NHibernate — one of the oldest and mature ORMs for .NET, ported from Java ORM Hibernate. It is powerful, flexible, supports many features, but has a steeper learning curve compared to Entity Framework.
My most extensive experience is with Entity Framework Core, which I actively used in projects with SQL Server, PostgreSQL, and SQLite. Dapper was used in scenarios requiring maximum performance and query control, such as working with large volumes of data or specific stored procedures. I used NHibernate in older projects where its flexibility and mapping features were needed.