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
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.
.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
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.
🦄 .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)
Fluent migrations framework for .NETProject 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 . 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 . 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.
 - https://github.com/mbdavid/LiteDB
Entity Framework Core provider for MySQL and MariaDB built on top of MySqlConnectorProject 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 Object Relational MapperProject mention: How to use performant Guid as primary keys in databases. UUID Version 7 to the rescue! | reddit.com/r/dotnet | 2022-12-28
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.
Official PetaPoco, A tiny ORM-ish thing for your POCO'sProject mention: Classic ASP Website with Microsoft Access - What to convert to? | reddit.com/r/dotnet | 2022-07-21
A small, happy, dynamic MicroORM for .NET that will love you forever.
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.
A hybrid ORM library for .NET.Project mention: Dapper is die? | reddit.com/r/dotnet | 2023-03-16
What about repodb?
LINQKit is a free set of extensions for LINQ to SQL and Entity Framework power users.
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 = MyBatis in C# + .NET Core+ Cache(Memory | Redis) + R/W Splitting + PropertyChangedTrack +Dynamic Repository + InvokeSync + Diagnostics
Simple microORM that maps the results of a query onto a POCO object. Project based on Schotime's branch of PetaPoco
Fast, lightweight .NET micro-ORM
Handle database errors easily when working with Entity Framework Core. Supports SQLServer, PostgreSQL, SQLite, Oracle and MySql
Map POCO objects to Excel files
CRUD for Dapper
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 - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
C# ORM related posts
Dapper is die?
4 projects | reddit.com/r/dotnet | 16 Mar 2023
How do I drop a database from a server without the database file being deleted using c#?
1 project | reddit.com/r/csharp | 13 Mar 2023
Why keep EF Core migrations in a separate project?
2 projects | reddit.com/r/dotnet | 9 Mar 2023
EFCore Many-to-Many: any way to prevent inefficient sub-select without a round-trip?
2 projects | reddit.com/r/csharp | 8 Mar 2023
ELI5 SDK.NET for ESRI products
4 projects | reddit.com/r/gis | 6 Mar 2023
EF Core team works on issues depending on the likes. Does that accurately represent what should be worked on?
1 project | reddit.com/r/dotnet | 5 Mar 2023
How to profile this code?
1 project | reddit.com/r/dotnet | 24 Feb 2023
A note from our sponsor - SonarLint
www.sonarlint.org | 25 Mar 2023
What are some of the best open-source ORM projects in C#? This list will help you:
|5||LINQ to DB||2,558|
|14||Entity Framework 6||1,377|
|23||LINQ to Twitter||499|