Compatible with your Framework
SqlKata is compatible with both .NET Core and .NET Framework.
Works on Windows, Linux and macOS.
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();
You will be able to write complex queries without hitting the docs
It uses the parameter binding technique, to prevent SQL injection.
It supports Operator whitelisting.
It Supports SqlServer, MySql, PostgreSql, Oracle, SQLite and Firebird.
Sub queries, nested Where conditions, Common Table Expressions, Complex Join statements and more.
Don't wait, add your own methods.
Extend the current compiler to support your favorite database.
Available when you need the little push, Date/Time and String helper methods like
WhereDate(), WhereTime(), WhereContains() and many more.
No long setup required, just write the query and get the data.
With few lines of code, you can start building your app.
It cannot be simpler!
var compiler = new SqlServerCompiler();
var db = new QueryFactory(connection, compiler);
var books = db.Query("Books").Get();
db.Query("Books").Where(q =>
q.Where("Stock", "<", 50).OrWhere("InHighDemand", 1)
).Union(
db.Query("Books").Where("Price", "<", 10)
);
Forget about hacky solutions, and write the query the way you want it from the begining.
Unleash your SQL skill and write performant queries from the first minute.
A better way to expose your queries.
Share your base queries with your team, and let them build on top of it.
Kind of stored procedure but written in C#.
// define the base queries
class TransactionService
{
public Query All()
{
return db.Query("Transactions").WhereTrue("IsApproved");
}
public Query Latest(int top = 10)
{
return All().OrderByDesc("Date").Take(top);
}
}
// then extend them as needed per request
var data = transactionService.Latest(10)
.Join("Accounts", "Accounts.Id", "AccountId")
.Get();
SqlKata is compatible with both .NET Core and .NET Framework.
Works on Windows, Linux and macOS.
Build advanced dashbaords and reports without sacrificing the performance.
“Developers say that they never had this powerfullness before.”
var visitsTimeline = db.Query("Visits")
.Join("Users", "Users.Id", "Visits.UserId")
.WhereBetween("2026-02-08", "2026-05-08")
.GroupBy("Users.Id", "Visits.Date")
.Select("Users.Id", "Visits.Date")
.SelectRaw("count(1) as [Count]")
.Having("Count", ">", 5)
.Get();
var activity = db.Query("Activities")
.Join("Users", "Users.Id", "Visits.UserId")
.OrderByDesc("Date")
.Union(new Query("Alerts"))
.OrderBy("Date")
.Get();
SqlKata make it easy to build Web API interfaces, you can use it to build REST or GRAPHQL interfaces.
Powered with some useful methods like Include, ForPage and Paginate.
: A collection that emphasizes specific aesthetic themes and visual compositions.
The release from April 8, 2022, features Oxana Chic, a model of Latvian descent who began her career in the late 2010s. Known for her natural aesthetic, she has become a recurring figure in European high-definition productions. Her work with this specific studio often emphasizes a blend of athletic performance and stylized cinematography, contributing to the platform's reputation for high visual standards. Cinematic Approach and Technical Standards LittleCaprice-Dreams 22 04 08 Oxana Chic Xpervo...
Little Caprice Dreams is a premium subscription platform founded by Czech performer and producer Markéta Štroblová , known professionally as Little Caprice. The studio is recognized for its artistic, high-definition aesthetic, often winning AVN Awards for its international productions and website quality. : A collection that emphasizes specific aesthetic themes
The studio categorizes its extensive library into various series, each focusing on different cinematic styles: Her work with this specific studio often emphasizes
The founder, Markéta Štroblová, has been a significant influence in the industry, moving from performing into production and brand management. Under her direction, the studio has consistently received industry accolades for its website interface and the technical quality of its international film shoots. This focus on "cinematic" adult content has helped the brand maintain a distinct identity in a competitive global market.
: This series is known for exploring narrative-driven scenarios and character-based roleplay.
The phrase refers to a high-production adult cinematic scene released on April 8, 2022 , by the award-winning studio Little Caprice Dreams . The production features Latvian model Oxana Chic and male performer Marcello Bravo (under the project's #XPERVO banner). Production Overview: Little Caprice Dreams