SqlKata

SqlKata is an elegant Sql Query Builder for C#, it helps you to talk with your database engine with a higher order of freedom, it allows you to write complex queries in an Object Oriented Manner, helpful when you need: Complex Reports using subqueries, join, union, CTE and nested conditions Database Abstraction dealing with multiple database vendors, write your query once, and SqlKata will compile it to the needed Database Dynamic Queries building your queries on runtime is a must when you have an interactive dashboard Speed is a matter Unlike Entity Framework, SqlKata doesn't know about your entities, and doesn't keep track of them, so no additional memory consumption, just fetch and send, and also it uses Dapper for the Query Execution so performance here is unbeatable