SqlKata the dotnet SQL query builderBuild dynamic SQL queries, with confidence A fluent SQL query builder for C# var query = db.Query("Books").OrderByDesc("PublishingDate"); if(Request.Has("category.name")) { var category = Request.Get("category.name"); query.Join("Categories", "Categories.Id", "Books.CategoryId") .Where("Categories.Name", category); } var recentBooks = query.Limit(10).Get();
