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.
⚠️ : The creator explicitly warns that people have been banned from online play for using modded saves. Use save editors and pre‑made saves only for offline play.
A: The Yuzu emulator is offline by default. If you are using Yuzu purely for local single-player or local multiplayer, the risk is zero. However, if you are using a network mod to play "online," using a flagrantly hacked save file (like one with unrealistic stats) could potentially lead to a ban from those unofficial server communities.
Once you have downloaded a verified 100% save file , follow these steps precisely. super smash bros ultimate 100 save file yuzu
installed and running on your system. Yuzu is a free, open‑source Nintendo Switch emulator that allows you to play Switch games on PC. (Note: official Yuzu development has been discontinued, but existing builds still work well.)
inside this folder and paste them into a secure backup folder on your desktop. Step 2: Download a Verified 100% Save File ⚠️ : The creator explicitly warns that people
Skips dozens of hours of repetitive spirit battles.
The save was created with a different DLC/update version or on a different Switch console (certificate mismatch). Solution: Ensure your Smash Ultimate NSP/XCI is updated to the exact same version as the save file (preferably 13.0.2). Use Yuzu's Install File to NAND option for update patches. Also, try using Ryujinx emulator first, save a dummy file, then replace it – sometimes Ryujinx is less strict with save signatures. If you are using Yuzu purely for local
⚠️ : Avoid sketchy file‑sharing sites that bundle adware or malware. Stick to well‑known communities like GBAtemp and GitHub.
For manual verification, the typical path where Yuzu stores your Switch saves looks like this: