Dapper Extensions vs LINQKit

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. (by tmsmith)

ORM

Source Code

Suggest alternative

Edit details

LINQKit

LINQKit is a free set of extensions for LINQ to SQL and Entity Framework power users. (by scottksmith95)

ORM

Source Code

Suggest alternative

Edit details

Our great sponsors

InfluxDB - Power Real-Time Data Analytics at Scale

WorkOS - The modern identity platform for B2B SaaS

SaaSHub - Software Alternatives and Reviews

Our great sponsors

Dapper Extensions		LINQKit
	Project
-	Mentions	6
1,773	Stars	1,563
-	Growth	-
0.0	Activity	3.5
2 months ago	Latest Commit	3 months ago
C#	Language	C#
-	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 Extensions

Posts with mentions or reviews of Dapper Extensions. We have used some of these posts to build our list of alternatives and similar projects.

We haven't tracked posts mentioning Dapper Extensions yet.
Tracking mentions began in Dec 2020.

LINQKit

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

What your hidden nuget gems ?
32 projects | /r/dotnet | 10 Mar 2023

I also enjoy LinqKit (mentioned here). Really cool way to build a LINQ predicate.
EF Core Include where
1 project | /r/dotnet | 18 Feb 2022

I would suggest to install LINQKit Configure DbContextOptions: cs builder .UseSqlServer(connectionString) .WithExpressionExpanding(); // enabling LINQKit extension
Як я мігрував з EF 6 до EF Core 5
1 project | dev.to | 26 Oct 2021
Build dynamic Linq filters (aka. where() predicates)
3 projects | /r/dotnet | 4 Jun 2021

Nice! At work we do something similar, but we use the predicate builder of linqkit: https://github.com/scottksmith95/LINQKit
Expression<Func<T>> usage in filters and sorting
1 project | /r/dotnet | 14 Apr 2021

To answer your other question, you can use something like PredicateBuilder to compose predicates for use in Where and OrderBy methods. To define your OrderBy with a boolean (or string or enum) to denote the ordering, you would have to make an extension method like so:

What are some alternatives?

When comparing Dapper Extensions and LINQKit you can also consider the following projects:

Dapper.FastCRUD - fast & light .NET ORM for strongly typed people

Linq.Expression.Optimizer - System.Linq.Expression expressions optimizer. http://thorium.github.io/Linq.Expression.Optimizer

MongoDB Repository pattern implementation

dynamic-linq-query-builder - A truly generic and dynamic linq query builder to compliment jQuery QueryBuilder and other dynamic linq query generation needs

System.Linq.Dynamic.Core - The .NET Standard / .NET Core version from the System Linq Dynamic functionality.

LINQ to DB - Linq to database provider.

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

NPoco - Simple microORM that maps the results of a query onto a POCO object. Project based on Schotime's branch of PetaPoco

Fluent NHibernate - Fluent NHibernate!