querybuilder
querybuilder copied to clipboard
sqlkata
SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird
Missing .ConfigureAwait(false) on async method calls was causing deadlocks in our application. Added modifier to all async methods in QueryBuilder and SqlKata.Execution libraries. Also added ConfigureAwaitChecker.Analyzer nuget package to help...
Hello, I noticed some performance issue with insert many on big collection. It looks like there are few reasons - unnecessary cast to list - using string operator instead of...
Basically all Oracle databases I have seen automatically convert object names to uppercase, which makes us have to write ugly c# code like ```csharp public class Foo { public string...
The procedure name is not being escaped correctly. select * from "TEST(1)"; instead of select * from "TEST"(1);
Note: this follows #499 (so some duplicate commits show up), but it doesn't seem possible to set the base branch correctly. This enables the writing of queries like `SELECT MIN(COLUMN),...
This adds support for the following two syntaxes: ##### `SelectAs()` ``` Query().SelectAs(("Row1", "Alias1"), ("Row2", "Alias2")).From("Table"); --> "SELECT [Row1] AS [Alias1], [Row2] AS [Alias2] FROM [Table]" ``` ##### Aggregates aliases `SelectAggregate()`...
I managed to resolved Include and includeMany in SqlKata.Execution project at QueryFactory.cs file . Please check if there no conflict with other feature of the library? Cheers
Provides the feasibility to have parameter placeholder in the select statement by escaping them. This also provides the capability to override the parameter placeholder and escape character. Ex => var...
Allow mixing parameterized insert queries & query inserts. This is very useful when you have some of the data, but is looking to get the rest of the data directly...
Fixes this issue: https://stackoverflow.com/a/66070044/384853 Now you can have empty opening and closing identifiers.
