DotNet-ORM-Cookbook
Tortuga Chain
| DotNet-ORM-Cookbook | Tortuga Chain | |
|---|---|---|
| 9 | 11 | |
| 334 | 335 | |
| 0.9% | 0.0% | |
| 0.0 | 6.1 | |
| almost 2 years ago | about 1 month ago | |
| C# | C# | |
| The Unlicense | GNU General Public License v3.0 or later |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
DotNet-ORM-Cookbook
- Dapper vs. Entity Framework With Postgres
-
How do you do DB crud for your .NET apps? EF? Dapper? ADO.NET?
ORM Cookbook: https://tortugaresearch.github.io/DotNet-ORM-Cookbook/
- What is the best PostgreSQL ORM tool for use in a .NET Framework 4.7 application?
-
What was used before LINQ to SQL
Here is a list of examples using ADO and NHibernate. https://tortugaresearch.github.io/DotNet-ORM-Cookbook/
-
"ORMs have a special place in my heart, not entirely unlike Brutus and Caesar: a dear friend who betrays you and leaves you to die a slow, painful death." – Taming SQL and ORMs with sqlc
You can see a comparison in the ORM Cookbook. https://tortugaresearch.github.io/DotNet-ORM-Cookbook/ and this (out of date) post https://github.com/TortugaResearch/Chain/wiki/A-Chain-comparison-to-Dapper.
- Alternatives to EF.Core
-
Why most people use Dapper instead of EF Raw Queries?
The .NET ORM Cookbook revealed some areas where it could be improved. https://github.com/TortugaResearch/DotNet-ORM-Cookbook
-
Warning about Dapper + PostgreSQL in .NET 6
I was really surprised when I updated the ORM Cookbook to .NET 6 and saw this. If you want to play with the code, it is at... https://github.com/Grauenwolf/DotNet-ORM-Cookbook
Tortuga Chain
- Resistance to use Entityframework !!
-
C# 11 Raw String Literals Explained
I mean, look at this mess: https://github.com/TortugaResearch/Tortuga.Chain/blob/main/Tortuga.Chain/Tortuga.Chain.SqlServer/shared/SqlServer/SqlServerMetadataCache.cs
- Does anyone know how I can return character length limits from a query?
- PostgreSQL 14 Breaks the .NET and Java Drivers for PostgreSQL - New features don't play nice with legacy workarounds
-
What was used before LINQ to SQL
Omg I didn’t realize this was you: https://github.com/TortugaResearch/Chain
-
"ORMs have a special place in my heart, not entirely unlike Brutus and Caesar: a dear friend who betrays you and leaves you to die a slow, painful death." – Taming SQL and ORMs with sqlc
You can see a comparison in the ORM Cookbook. https://tortugaresearch.github.io/DotNet-ORM-Cookbook/ and this (out of date) post https://github.com/TortugaResearch/Chain/wiki/A-Chain-comparison-to-Dapper.
-
Traits for C#
Here is a real example from the ORM that I built this for: https://github.com/TortugaResearch/Chain/blob/Traits/Tortuga.Chain/Tortuga.Chain.Access/Generated/Tortuga.Shipwright/Tortuga.Shipwright.TraitGenerator/Tortuga.Chain.Access.AccessDataSourceBase.cs
- Why most people use Dapper instead of EF Raw Queries?
- Check if a column allows nulls
- EF/Dapper vs Custom-developed ORM
What are some alternatives?
Entity Framework - EF Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations.
Dapper - Dapper - a simple object mapper for .Net [Moved to: https://github.com/DapperLib/Dapper]
SQLDelight - SQLDelight - Generates typesafe Kotlin APIs from SQL
LINQ to DB - Linq to database provider.
DataAccessGeneration - Better SQL Server stored procedure calls from C#
squid - 🦑 Provides SQL tagged template strings and schema definition functions.
TypeORM - ORM for TypeScript and JavaScript. Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.
Sequel - Sequel: The Database Toolkit for Ruby
SQLProvider - A general F# SQL database erasing type provider, supporting LINQ queries, schema exploration, individuals, CRUD operations and much more besides.
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.
NPoco - Simple microORM that maps the results of a query onto a POCO object. Project based on Schotime's branch of PetaPoco