C# ORM

Open-source C# projects categorized as ORM

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-13

    I 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)

  • FluentMigrator

    Fluent migrations framework for .NET

    Project mention: How do you deal with merging Entity Framework feature migrations into your main branch? | reddit.com/r/dotnet | 2022-12-08
  • LINQ to DB

    Linq to database provider.

    Project mention: LiteDB: A .NET embedded NoSQL database | news.ycombinator.com | 2022-11-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.

    [1] - https://github.com/mbdavid/LiteDB

    [2] - https://github.com/linq2db/linq2db

  • Pomelo.EntityFrameworkCore.MySql

    Entity Framework Core provider for MySQL and MariaDB built on top of MySqlConnector

    Project mention: Mysql and Entity | reddit.com/r/csharp | 2023-03-10

    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

  • NHibernate

    NHibernate Object Relational Mapper

    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.

  • PetaPoco

    Official PetaPoco, A tiny ORM-ish thing for your POCO's

    Project mention: Classic ASP Website with Microsoft Access - What to convert to? | reddit.com/r/dotnet | 2022-07-21
  • Massive

    A small, happy, dynamic MicroORM for .NET that will love you forever.

  • 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.

  • Fluent NHibernate

    Fluent NHibernate!

  • RepoDb

    A hybrid ORM library for .NET.

    Project mention: Dapper is die? | reddit.com/r/dotnet | 2023-03-16

    What about repodb?

  • LINQKit

    LINQKit is a free set of extensions for LINQ to SQL and Entity Framework power users.

    Project mention: What your hidden nuget gems ? | reddit.com/r/dotnet | 2023-03-10

    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

  • Insight.Database

    Fast, lightweight .NET micro-ORM

    Project mention: What your hidden nuget gems ? | reddit.com/r/dotnet | 2023-03-10
  • EntityFramework.Exceptions

    Handle database errors easily when working with Entity Framework Core. Supports SQLServer, PostgreSQL, SQLite, Oracle and MySql

    Project mention: What your hidden nuget gems ? | reddit.com/r/dotnet | 2023-03-10
  • ExcelMapper

    Map POCO objects to Excel files

  • MicroOrm.Dapper.Repositories

    CRUD for Dapper

  • 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.

  • LINQ to Twitter

    LINQ Provider for the Twitter API (C# Twitter Library)

  • 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

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