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
Hi, Since SqlKata supports creating insert queries from an `IEnumerable`, I think it would be great if we can also have an `AsInsert()` overload that takes an enumerable of that....
Hi ! I noticed SqlKata was able to insert multiple records with one query by providing an `IEnumerable` as columns `IEnumerable` as values; which works great, however it feels a...
Maybe need to add method query.AsExists() or any other for do this?
https://www.postgresql.org/docs/current/sql-merge.html Is it possible to add support for this command? Thanks
I ended up figuring it out myself :) seems like this is the only way to catch most of (if not all, since, we never know...) the possible input errors...
Oracle: Oracle Database 21c Express Edition SQLKata: 3.2.3 .NET 6 C#: ```csharp var columns = new [] {"Name", "Price"}; var valuesCollection= new [] { new object[] { "A", 1000 },...
I see a method on `QueryFactory` named `GetMultiple` and the async variation `GetMultipleAsync` but there are no docs about them, on the source code I can see that it is...
Added joins on UPDATE query. Results as ``` UPDATE [Test1] SET [Test1].[Test1Id] = 1 , [Test1].[Test1Description] = 'Name2Value' FROM [Test1]\nLEFT JOIN [Test] ON [Test].[TestId] = [Test1].[Test1Id] ```
Take the following database table: Table: Students ID (int) - FirstName (string) - LastName (string) Use the following query: `var qry = new SqlKata.Query("Students").Select("UnknownCol")` You will receive the string literal...
mysql ```mysql insert ignore into tbl values (1,2); ``` postgresql ```PLpgSQL insert into tbl values (1,2) on conflict do nothing; ```
