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

Dapper Alternatives

Similar projects and alternatives to Dapper

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better Dapper alternative or higher similarity.

Suggest an alternative to Dapper

Reviews and mentions

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 2021-08-10.
  • Dapper & CQRS
    2 projects | dev.to | 10 Aug 2021
    The "legacy stack" as it came to be known was written in .Net 4.5.3 using Entity Framework and the classic repository / unit of work pattern. As we worked with Entity Framework Core in .Net Core we found that we were not improving our query speeds. They were still slow. Usually in the area of 250ms on up based on the query. Entity Framework wasn't going to cut it for this "new stack" code. We decided to try Dapper. Along with Dapper we decided to adopt a different pattern with how our back end code would be structured and data would be delivered. After reading quite a bit about CQRS (Command Query Responsibility Segregation) and finding some great examples online we settled on this pattern. This article in particular was very useful. Though we didn't follow it exactly, we stole quite a few ideas from it.
  • How do I get the data more easily? Noob Ado.Net question.
    1 project | reddit.com/r/csharp | 6 Aug 2021
  • Using Dapper over EntityFramework for database operations in .NET Core
    2 projects | dev.to | 28 Jun 2021
    Dapper is a simple object mapper for .NET and owns the title of King of Micro ORM in terms of speed and is virtually as fast as using a raw ADO.NET data reader. Dapper operates directly using the IDbConnection interface which is extended by database providers like SQL Server, Oracle, MySQL etc. for their database.
  • Querying an Azure SQL Database from C# in 2021
    1 project | reddit.com/r/dotnet | 23 Jun 2021
    If you are talking about the hard coded sql query in the code, well first I am not using any Query Builder and second don't worry it is just an example to show the query I am doing. I could have used a stored procedure as well but but having just the stored procedure name would not have help people to reproduce my example. Besides most ORM (EF Core included) allow you to specify a raw sql query so it's a question of a C# feature here. And I am using an ORM here which is Dapper, maybe not as much features as other ORMs but it works fine and has a very good performance compared to other (although I think EF Core in .NET 6 is supposed to be almost as performant as Dapper).
  • Leakati dati vaccinali di sette milioni di Italiani, sono in vendita sul Dark Web.
    1 project | reddit.com/r/italy | 12 Jun 2021
  • PostgreSQL UUID vs. Serial vs. Identity
    10 projects | news.ycombinator.com | 31 May 2021
    The problem is when reading the data back with Dapper (writing works fine) and it has to parse the guid stored in sqlite back into a .net Guid. Thus I resorted to making the column type text and ToString() all the Guid's before writing, but that's pretty gross. With a normal string field, sqlite can set it as primary key, make unique indexes on it, use it as foreign keys. Thus my attempt to use my own generator the generate id's. So far it works great but not sure if it will be fine with 5 years of usage (basically on tables that keep growing over time, like a comments table).

    But of a rabbit hole: https://github.com/DapperLib/Dapper/pull/1082

  • Is it possible to convert sql string to LINQ expression?
    1 project | reddit.com/r/csharp | 26 Apr 2021
    Are you maybe searching for sometrhing like Dapper?


Basic Dapper repo stats
6 days ago

DapperLib/Dapper is an open source project licensed under GNU General Public License v3.0 or later which is an OSI approved license.

Scout APM: A developer's best friend. Try free for 14-days
Scout APM uses tracing logic that ties bottlenecks to source code so you know the exact line of code causing performance issues and can get back to building a great product faster.
Find remote C# jobs at our new job board 99remotejobs.com. There are 2 new remote jobs listed recently.
Are you hiring? Post a new remote job listing for free.