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 was your experience upgrading from .NET 5 to .NET 6? | reddit.com/r/csharp | 2021-11-28
Best ORM Fastest ORM Simple Easy Sqlite orm Oracle ORM Mysql Orm postgresql ORm SqlServer oRm 达梦 ORM 人大金仓 ORM 神通ORM C# ORM
Your Free Guide to Become Microsoft Azure Certified. Get this free guide to learn about different Azure certifications, what fits your current role, preparation resources, and freelancing platforms for Azure professionals to earn income
🦄 .NET orm, Mysql orm, Postgresql orm, SqlServer orm, Oracle orm, Sqlite orm, Firebird orm, 达梦 orm, 人大金仓 orm, 神通 orm, 翰高 orm, 南大通用 orm, MsAccess orm. (by dotnetcore)
Fluent migrations framework for .NETProject mention: Is it sensible to run EF migrations at startup? | reddit.com/r/dotnet | 2021-11-24
Linq to database provider.Project mention: What are your fav internal project(s)? | reddit.com/r/dotnet | 2021-08-31
Working on linq2db project. Model generation included. Faster than Dapper, better support of LINQ than EF Core. And I'm usually do not write SQL, library produces well formatted, optimised and predictable queries.
Entity Framework Core provider for MySQL and MariaDB built on top of MySqlConnectorProject mention: Question about C# and MySql | reddit.com/r/csharp | 2021-02-18
For MySQL and friends you'll need the Pomelo data provider from https://github.com/PomeloFoundation/Pomelo.EntityFrameworkCore.MySql . Turns out there's an example of using the MySQL provider about halfway down that shows how to, but it is missing the '-o Model' parameter that you'd use to get your database model into a folder called Model.
NHibernate Object Relational MapperProject mention: Is there a widely used hibernate-like ORM framework for .net core? | reddit.com/r/dotnet | 2021-04-29
NHibernate works with .NET core: https://github.com/nhibernate/nhibernate-core
Run Linux Software Faster and Safer than Linux with Unikernels.
Official PetaPoco, A tiny ORM-ish thing for your POCO'sProject mention: am i going mad? | reddit.com/r/csharp | 2021-03-30
A small, happy, dynamic MicroORM for .NET that will love you forever.
Fluent NHibernate!Project mention: Are Java developers obsessed with annotations? | reddit.com/r/java | 2021-07-29
Another example is Fluent NHibernate. Look how they map a class to the database:
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.
Fast, Simple, Typed ORM for .NETProject mention: Migrating Facebook to MySQL 8.0 | news.ycombinator.com | 2021-07-23
[ServiceStack OrmLite] does just that, all our development is done locally using SQLite but then deployments use MySQL. We do fall into the 'program is simple enough' category though.
A hybrid ORM library for .NET.Project mention: Mayroon bang mga killalang pilipino na open source na project? | reddit.com/r/PinoyProgrammer | 2021-09-02
Ung RepoDB na ORM sa .NET https://github.com/mikependon/RepoDB
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.Project mention: Ask HN: What tangible benefits did you get from spending time on HN? | news.ycombinator.com | 2021-03-06
Every so often, posts from Bruce Dawson's blog get posted here - one such post was about using Event Tracing for Windows to diagnose an issue with an NTFS lock being held causing 63 cores to idle while 1 does all the work.
A few months later, some other people in my team were struggling to diagnose an issue in production where a legacy webapp was struggling to scale up and fully use all 64 cores of the server we needed it to run on. I stepped in to help and remembered that post I'd seen on HN. We used ETW (through Windows Performance Recorder and Windows Performance Analyzer) to profile our app and I looked into the Wait Analysis. Turns out that Entity Framework 6 uses a ReaderWriterLockSlim to guard a cache, and that particular lock performs extremely poorly under heavy contention. Heavy in our case meant that for a single page build of one of this app's "hot path" pages, this lock would be taken a few hundred thousand times. We weren't the first to discover this:
What some other people in my team were struggling with for about two weeks was resolved in a single day thanks to me goofing off and reading HN. (We ultimately used a fork of EF6 that didn't suffer from this issue to solve our problem)
LINQKit is a free set of extensions for LINQ to SQL and Entity Framework power users.Project mention: Як я мігрував з EF 6 до EF Core 5 | dev.to | 2021-10-26
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
CRUD for Dapper
LINQ Provider for the Twitter API (C# Twitter Library)
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.Project mention: Parsing Excel to JSON in c# | reddit.com/r/csharp | 2021-07-16
You can use npoi mapper to read all excel rows to list, and then convert it to json.
The fastest micro-orm extension for DapperProject mention: 100 stars in Github - Dapper Query Builder using String Interpolation | reddit.com/r/dotnet | 2021-04-08
Regarding CUD (inserts/updates/deletes), I think Dommel works similarly to Dapper.FastCRUD and Dapper.SimpleCRUD, and those two look a little more mature in my opinion (not sure, but I really have the impression that Dommel is targeted at people who like this LINQ intellisense).
Map POCO objects to Excel filesProject mention: Read Excel file in .NET 6 deployed on Linux? | reddit.com/r/dotnet | 2021-11-27
You should take a look at ExcelMapper https://github.com/mganss/ExcelMapper
C# ORM related posts
How was your experience upgrading from .NET 5 to .NET 6?
1 project | reddit.com/r/csharp | 28 Nov 2021
How to handle long SQL commands?
2 projects | reddit.com/r/csharp | 26 Nov 2021
Is it sensible to run EF migrations at startup?
5 projects | reddit.com/r/dotnet | 24 Nov 2021
We need to have a talk about making life easier for newcomers to .NET
3 projects | news.ycombinator.com | 15 Nov 2021
Entity Framework Core 6 will not scaffold 'pure' many to many tables anymore
1 project | reddit.com/r/dotnet | 1 Nov 2021
Як я мігрував з EF 6 до EF Core 5
1 project | dev.to | 26 Oct 2021
SQL Server temporal tables in EF Core 6.0
1 project | reddit.com/r/dotnet | 14 Oct 2021
What are some of the best open-source ORM projects in C#? This list will help you:
|5||LINQ to DB||2,195|
|14||Entity Framework 6||1,284|
|20||LINQ to Twitter||436|
Are you hiring? Post a new remote job listing for free.