Dapper vs Entity Framework

Dapper

Dapper - a simple object mapper for .Net (by DapperLib)

Source Code

Suggest alternative

Edit details

Entity Framework

EF Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations. (by dotnet)

ORM entity-framework Database C# dotnet-core dotnet-standard dotnet-framework aspnet-product HacktoberFest

Source Code

docs.microsoft.com

Suggest alternative

Edit details

Our great sponsors

WorkOS - The modern identity platform for B2B SaaS

InfluxDB - Power Real-Time Data Analytics at Scale

SaaSHub - Software Alternatives and Reviews

Our great sponsors

Dapper		Entity Framework
	Project
40	Mentions	87
17,128	Stars	13,342
1.1%	Growth	1.3%
8.0	Activity	9.9
14 days ago	Latest Commit	1 day ago
C#	Language	C#
GNU General Public License v3.0 or later	License	MIT License

The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
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.

Dapper

Posts with mentions or reviews of Dapper. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2024-01-27.

Working with Dapper/SQL-Server Framework 4.8 C#
2 projects | dev.to | 27 Jan 2024

In both samples to get all records and to get a single record works fine but there is a better way to perform the same work using NuGet package Dapper. Dapper is extremely easy to use and built with performance in mind. In the source code provided the basic operations are covered, to take things to the next level and read the information at GitHub, the following page and other code samples in the following repository.
Working with Dapper in C#
2 projects | dev.to | 30 Oct 2023

In this article learn how to use Dapper an open-source object-relational mapping (ORM) library for .NET and .NET Core applications. Unlike many articles out there, this one will provide source code to try everything out that is shown in an easy-to-follow way by beginning with a single table then in part two of this series will work with multiple tables.
Interceptors (new C# metaprogramming feature) to fuel DapperAOT development
3 projects | news.ycombinator.com | 21 Jun 2023
API REST C# Entity Framework y SQL
2 projects | /r/programacion | 10 Jun 2023
Integration Testing Postgres Store
4 projects | dev.to | 3 Jun 2023

Dapper
REST API using C# .NET 7 with MySql
6 projects | dev.to | 24 May 2023

I will be using Dapper - a simple object mapper for .Net along with MySqlConnector.
Resources for learning minimal API using dapper in .net
1 project | /r/webdev | 27 Apr 2023

Maybe the more basic approach to dapper is their documentation https://github.com/DapperLib/Dapper the readme but again most likely you not gonna understand
SQL Connection Question
1 project | /r/learncsharp | 20 Mar 2023

I think EF Core & EF are the successors to LINQ to SQL that you'd wanna look into, and/or Dapper if you wanna go lower.
Dapper is die?
4 projects | /r/dotnet | 16 Mar 2023

The main maintainers of Dapper no longer work at Stack, but they're active enough to comment on recent pull requests: https://github.com/DapperLib/Dapper/pull/1887.
Is MSSQL Server the easiest sql database to integrate with a C# .NET application?
1 project | /r/csharp | 3 Mar 2023

MarieDB and dapper https://github.com/DapperLib/Dapper

Entity Framework

Posts with mentions or reviews of Entity Framework. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-10-16.

Multi-tenancy using schemas with Entity Framework and PostgreSQL
2 projects | dev.to | 16 Oct 2023

* You can check the original CreateMigration implementation at: https://github.com/dotnet/efcore/blob/release/7.0/src/EFCore.Relational/Migrations/Internal/MigrationsAssembly.cs
Linux or Windows for .net development?
1 project | /r/dotnet | 14 Aug 2023

Since .net core came out it's possible to run and write .net code in all platforms. In your experience what is the best when it comes to development experience and resources consumption? I recently moved to Linux Mint as my daily driver and felt that .net on Windows just works better, even with Rider. I struggled with an issue "Platform not supported exception" when trying to connect with the database using EF Core and NET 6.0. A lot of issues about this matter were opened on GitHub and closed without a proper resolution and the Microsoft teams seems to not give a shit about that, most workaround came from the user's who took their time to investigate the issue.
Show HN: Tankman – An Open Source User Management and Authorization MicroService
2 projects | news.ycombinator.com | 6 Jul 2023

Thanks Dave. Looks like sequelize has TypeScript support.
On another note: one of the goals of Tankman is to compile with Native AOT once .Net 8 is out. The EF Core team is working on making it compatible - https://github.com/dotnet/efcore/issues/29754
EF Core/NET 6 - How to execute sql server stored procedure and get the result set?
1 project | /r/dotnet | 21 Jun 2023
Deploying sqlite database to android emulator
1 project | /r/dotnetMAUI | 16 Jun 2023

It’s a known issue in the Xamarin / .NET MAUI world. Here’s a GitHub Issue posted 5 years ago detailing the problem: https://github.com/dotnet/efcore/issues/12087
Duda carrera: C#/.NET vs. Node/Express
13 projects | /r/devsarg | 18 May 2023

Entity Framework: Licencia MIT.
Build time takes long
1 project | /r/dotnet | 11 May 2023

https://github.com/dotnet/efcore/issues/23291 seems like there was an issue but it has been resolved.
Newbie Entity Framework question. I get what EF does, but am unable to do anything without a tutorial.
1 project | /r/csharp | 6 May 2023

No they aren't. I don't know why you thought that link has anything to do with window functions. Here's the ticket in the backlog. https://github.com/dotnet/efcore/issues/12747
I want to start contributing to open-source .Net projects, but How do I learn large codebase?
4 projects | /r/dotnet | 21 Apr 2023

https://github.com/dotnet/efcore ,https://github.com/dotnet/aspnetcore , https://github.com/dotnet/maui - I've experience with developing android apps as well , may be I can contribute to this
Transforming Enumerable into Queryable with Linq: A How-To Guide on Concat, Union, and Troubleshooting EF Core 6 Errors
2 projects | dev.to | 4 Apr 2023

More Info: https://github.com/dotnet/efcore/issues/19129

What are some alternatives?

When comparing Dapper and Entity Framework you can also consider the following projects:

efcore-dapper-benchmark - A project that I have created to benchmark the read/write performance of EFCore vs Dapper

LINQ to DB - Linq to database provider.

Npgsql - Npgsql is the .NET data provider for PostgreSQL.

Dapper - Dapper - a simple object mapper for .Net [Moved to: https://github.com/DapperLib/Dapper]

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

FluentMigrator - Fluent migrations framework for .NET

Knex - A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, SQLite3 and Oracle, designed to be flexible, portable, and fun to use.

Hasura - Blazing fast, instant realtime GraphQL APIs on your DB with fine grained access control, also trigger webhooks on database events.

ServiceStack.OrmLite - Fast, Simple, Typed ORM for .NET

pg-ulid - ULID Functions for PostgreSQL

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.