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
I need a way to discern between Insert/Update so some attbt dont get updated. public class User { [Ignore] public int id{ get; set; } public string name{ get; set;...
https://github.com/sqlkata/querybuilder/issues/721 Related issue
Is there any way to generate queries as given below?? I did't find anything that can achieve as the followings. ``` SELECT * FROM "ProductStocks" ps where (ps."DepotId", ps."ProductId", ps."ProductBatchId")...
FYI I have seen issue #162 This is similar but I am trying to use `.WhereRaw()` with a string array. This is the raw SQL I am trying to accomplish:...
The `WITH` clause for CTEs needs to be able to support recursive CTEs under MySQL by using the `WITH RECURSIVE` syntax. Without the `RECURSIVE` keyword, self-referencing CTEs will fail with...
Here is the simple example showing the problem (even though it does not call SqlKata): ```c# [Fact] public void Dapper_WithSqlServerFailsWithRegularBinaryNullable() { // Arrange using var connection = new SqlConnection(Fixture.ConnectionString); connection.Open();...
Bumps [actions/download-artifact](https://github.com/actions/download-artifact) from 1 to 4.1.7. Release notes Sourced from actions/download-artifact's releases. v4.1.7 What's Changed Update @actions/artifact dependency by @bethanyj28 in actions/download-artifact#325 Full Changelog: https://github.com/actions/download-artifact/compare/v4.1.6...v4.1.7 v4.1.6 What's Changed updating @actions/artifact...
![dependabot[bot] avatar](https://avatars.githubusercontent.com/in/29110?v=4 "dependabot[bot] avatar"){kind=avatar}
Passing an IDictionary to .AsInsert() seems to result in an unhandled NullReferenceException SqlKata 2.4.0 SqlKata.Execution 2.4.0 # Example: ``` IDictionary obj = new ExpandoObject(); obj.Add("col1", "value"); QueryFactory queryFactory = new();...
Hi, I'm working with a SQL Server database and trying to execute a query that joins two tables: ParameterClasses and EquipmentClasses. Both tables contain a column named Id. However, the...
Hi, I'm running into a limitation when using InsertGetIdAsync (and similar methods) in conjunction with a custom implementation of IDbTransaction. Although the method signature indicates support for any IDbTransaction `public...
