Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://github.com/sqlkata/querybuilder below:

sqlkata/querybuilder: SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird

SqlKata Query Builder

Follow and Upvote SqlKata on Product Hunt to encourage the development of this project

SqlKata Query Builder is a powerful SQL query builder written in C#. It is secure, framework-agnostic, and inspired by top query builders like Laravel Query Builder and Knex.

• Expressive API: Clean and intuitive syntax similar to SQL.
• Database Agnostic: Work with multiple databases using a unified API.
• Complex Queries: Supports nested conditions, subqueries, conditional statements, and more.
• Execution Support: Use the SqlKata.Execution package to execute queries with Dapper.

$ dotnet add package SqlKata
$ dotnet add package SqlKata.Execution # (optional) If you want the execution support

var connection = new SqlConnection("...");
var compiler = new SqlCompiler();
var db = new QueryFactory(connection, compiler);

QueryFactory is provided by the SqlKata.Execution package.

var books = db.Query("Books").Get();

var books = db.Query("Books").WhereTrue("IsPublished").Get();

var introToSql = db.Query("Books").Where("Id", 145).Where("Lang", "en").First();

var recent = db.Query("Books").OrderByDesc("PublishedAt").Limit(10).Get();

var books = db.Query("Books")
    .Include(db.Query("Authors")) // Assumes that the Books table has an `AuthorId` column
    .Get();

This will include the property "Author" on each "Book":

var books = db.Query("Books")
    .Join("Authors", "Authors.Id", "Books.AuthorId")
    .Select("Books.*", "Authors.Name as AuthorName")
    .Get();

foreach(var book in books)
{
    Console.WriteLine($"{book.Title}: {book.AuthorName}");
}

var isFriday = DateTime.Today.DayOfWeek == DayOfWeek.Friday;

var books = db.Query("Books")
    .When(isFriday, q => q.WhereIn("Category", new [] {"OpenSource", "MachineLearning"}))
    .Get();

var page1 = db.Query("Books").Paginate(10);

foreach(var book in page1.List)
{
    Console.WriteLine(book.Name);
}

...

var page2 = page1.Next();

int affected = db.Query("Users").Insert(new {
    Name = "Jane",
    CountryId = 1
});

int affected = db.Query("Users").Where("Id", 1).Update(new {
    Name = "Jane",
    CountryId = 1
});

int affected = db.Query("Users").Where("Id", 1).Delete();

I announce updates on my Twitter Account, and you can subscribe to our newsletters from the website https://sqlkata.com.

It's impossible to support all available database vendors, which is why we focus on the major ones. We encourage you to create your own compiler for your database.

Unfortunately, no. The reason is that this would add overhead for the project contributors. We prefer to improve the quality of the existing compilers instead.

• ⭐ Star the project here on GitHub, and share it with your friends.
• 🐱‍💻 Follow and upvote it on Product Hunt:
• 💰 You can also donate to support the project financially on open collection.

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4