LINQKit
Linq.Expression.Optimizer
Our great sponsors
| LINQKit | Linq.Expression.Optimizer | |
|---|---|---|
| 6 | - | |
| 1,565 | 97 | |
| - | - | |
| 3.5 | 4.6 | |
| 3 months ago | 21 days ago | |
| C# | F# | |
| MIT License | The Unlicense |
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.
LINQKit
-
What your hidden nuget gems ?
I also enjoy LinqKit (mentioned here). Really cool way to build a LINQ predicate.
-
EF Core Include where
I would suggest to install LINQKit Configure DbContextOptions: cs builder .UseSqlServer(connectionString) .WithExpressionExpanding(); // enabling LINQKit extension
- Як я мігрував з EF 6 до EF Core 5
-
Build dynamic Linq filters (aka. where() predicates)
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
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:
Linq.Expression.Optimizer
We haven't tracked posts mentioning Linq.Expression.Optimizer yet.
Tracking mentions began in Dec 2020.
What are some alternatives?
dynamic-linq-query-builder - A truly generic and dynamic linq query builder to compliment jQuery QueryBuilder and other dynamic linq query generation needs
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.
System.Linq.Dynamic.Core - The .NET Standard / .NET Core version from the System Linq Dynamic functionality.
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.
NPoco - Simple microORM that maps the results of a query onto a POCO object. Project based on Schotime's branch of PetaPoco
MongoDB Repository pattern implementation
SqlSugar - .Net aot ORM Fastest ORM Simple Easy Sqlite orm Oracle ORM Mysql Orm postgresql ORm SqlServer oRm 达梦 ORM 人大金仓 ORM 神通ORM C# ORM , C# ORM .NET ORM NET5 ORM .NET6 ORM ClickHouse orm QuestDb ,TDengine ORM,OceanBase orm,GaussDB orm ,Tidb orm Object/Relational Mapping
LINQ to DB - Linq to database provider.
Dapper.FastCRUD - fast & light .NET ORM for strongly typed people
Fluent NHibernate - Fluent NHibernate!