Up your coding game and discover issues early. SonarLint is a free plugin that helps you find & fix bugs and security issues from the moment you start writing code. Install from your favorite IDE marketplace today. Learn more →
Top 23 C# ORM Projects
-
Entity Framework
EF Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations.
Project mention: How do I drop a database from a server without the database file being deleted using c#? | reddit.com/r/csharp | 2023-03-13I was curious about if there were built in methods in efcore to alter user rights and issues take offline commands and found this relevant issue. Basically since it's so different from one database system to another, it wouldn't be possible to keep portability and wasn't worth it. So they suggest running rawsql in migrations instead. You doing it via SqlCommand probably end up the same.
-
SqlSugar
.Net ORM Fastest ORM Simple Easy Sqlite orm Oracle ORM Mysql Orm postgresql ORm SqlServer oRm 达梦 ORM 人大金仓 ORM 神通ORM C# ORM , C# ORM .NET ORM NET5 ORM .NET6 ORM ClickHouse orm QuestDb
-
SonarLint
Clean code begins in your IDE with SonarLint. Up your coding game and discover issues early. SonarLint is a free plugin that helps you find & fix bugs and security issues from the moment you start writing code. Install from your favorite IDE marketplace today.
-
FreeSql
🦄 .NET orm, C# orm, VB.NET orm, Mysql orm, Postgresql orm, SqlServer orm, Oracle orm, Sqlite orm, Firebird orm, 达梦 orm, 人大金仓 orm, 神通 orm, 翰高 orm, 南大通用 orm, 国产 orm, Clickhouse orm, QuestDB orm, MsAccess orm. (by dotnetcore)
-
Project mention: How do you deal with merging Entity Framework feature migrations into your main branch? | reddit.com/r/dotnet | 2022-12-08
-
Before checking this out, people might want to take a look through the issues and pull requests of which there are 500+ and 50+ respectively [1]. I was really optimistic about this project and it was headed in a great direction, but it's not in a production ready state, and it seems that the main guy behind it has decided to move onto other things. It's been about a year since there was any significant activity.
I just mention this because a lot of these little issues might only become more apparent after integrating the db into your project and so it can be a bit annoying. I ended up swapping to Linq2DB [1]. It's something, more or less, similar offering an ORM/LINQ type system as well as the ability to also use direct SQL if desired. But the neat thing is that it also uses a standardized API for the LINQ query language, so you can do things like swap from SQLite to PostgreSQL in one* line of code, so long as you're not using any provider specific extensions.
-
Pomelo.EntityFrameworkCore.MySql
Entity Framework Core provider for MySQL and MariaDB built on top of MySqlConnector
EntityFramework uses providers to translate Linq queries into real queries and connect to the datasource and convert the data into .net readable format. The MySQL provider for .NET is the official one but I think it has fallen on hard times and is not developed as much as before. You should probably look at Pomelo, which is a community library for .net core: https://github.com/PomeloFoundation/Pomelo.EntityFrameworkCore.MySql
-
Project mention: How to use performant Guid as primary keys in databases. UUID Version 7 to the rescue! | reddit.com/r/dotnet | 2022-12-28
-
InfluxDB
Access the most powerful time series database as a service. Ingest, store, & analyze all types of time series data in a fully-managed, purpose-built database. Keep data forever with low-cost storage and superior data compression.
-
Project mention: Classic ASP Website with Microsoft Access - What to convert to? | reddit.com/r/dotnet | 2022-07-21
-
-
Dapper Extensions
Dapper Extensions is a small library that complements Dapper by adding basic CRUD operations (Get, Insert, Update, Delete) for your POCOs. For more advanced querying scenarios, Dapper Extensions provides a predicate system. The goal of this library is to keep your POCOs pure by not requiring any attributes or base class inheritance.
-
-
What about repodb?
-
I also enjoy LinqKit (mentioned here). Really cool way to build a LINQ predicate.
-
Entity Framework 6
This is the codebase for Entity Framework 6 (previously maintained at https://entityframework.codeplex.com). Entity Framework Core is maintained at https://github.com/dotnet/efcore.
-
SmartSql
SmartSql = MyBatis in C# + .NET Core+ Cache(Memory | Redis) + R/W Splitting + PropertyChangedTrack +Dynamic Repository + InvokeSync + Diagnostics
-
sharding-core
high performance lightweight solution for efcore sharding table and sharding database support read-write-separation .一款ef-core下高性能、轻量级针对分表分库读写分离的解决方案，具有零依赖、零学习成本、零业务代码入侵
-
NPoco
Simple microORM that maps the results of a query onto a POCO object. Project based on Schotime's branch of PetaPoco
-
-
EntityFramework.Exceptions
Handle database errors easily when working with Entity Framework Core. Supports SQLServer, PostgreSQL, SQLite, Oracle and MySql
-
-
-
Npoi.Mapper
Use this tool to import or export data with Excel file. The tool is a convention based mapper between strong typed object and Excel data via NPOI.
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
NOTE:
The open source projects on this list are ordered by number of github stars.
The number of mentions indicates repo mentiontions in the last 12 Months or
since we started tracking (Dec 2020).
The latest post mention was on 2023-03-16.
C# ORM related posts
- Dapper is die?
- How do I drop a database from a server without the database file being deleted using c#?
- Why keep EF Core migrations in a separate project?
- EFCore Many-to-Many: any way to prevent inefficient sub-select without a round-trip?
- ELI5 SDK.NET for ESRI products
- EF Core team works on issues depending on the likes. Does that accurately represent what should be worked on?
- How to profile this code?
-
A note from our sponsor - SonarLint
www.sonarlint.org | 25 Mar 2023
Index
What are some of the best open-source ORM projects in C#? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | Entity Framework | 12,322 |
| 2 | SqlSugar | 4,332 |
| 3 | FreeSql | 3,630 |
| 4 | FluentMigrator | 2,916 |
| 5 | LINQ to DB | 2,558 |
| 6 | Pomelo.EntityFrameworkCore.MySql | 2,427 |
| 7 | NHibernate | 2,058 |
| 8 | PetaPoco | 1,958 |
| 9 | Massive | 1,791 |
| 10 | Dapper Extensions | 1,697 |
| 11 | Fluent NHibernate | 1,642 |
| 12 | RepoDb | 1,546 |
| 13 | LINQKit | 1,378 |
| 14 | Entity Framework 6 | 1,377 |
| 15 | SmartSql | 936 |
| 16 | sharding-core | 890 |
| 17 | NPoco | 816 |
| 18 | Insight.Database | 796 |
| 19 | EntityFramework.Exceptions | 760 |
| 20 | ExcelMapper | 567 |
| 21 | MicroOrm.Dapper.Repositories | 565 |
| 22 | Npoi.Mapper | 506 |
| 23 | LINQ to Twitter | 499 |
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com