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
Hello, I am trying to see if it is possible to map results to an Property which is an object. public class Location { public Guid LocationId { get; set;...
With `SqliteCompiler`, when calling: `int insertedRowId = queryFactory.Query(TableName).InsertGetId(data);` with `data` being a: `Dictionary` a `System.Reflection.TargetParameterCountException` is thrown on: function: `private Dictionary BuildDictionaryFromObject(object data, bool considerKeys = false)` **(Query.cs, line 369)**...
I have an issue when try to use "?" not as a parameter in the 'Like' statement, but as part of word. For example "message like '%blabla?%". Currently I got...
When i use a join (which works as i can see when i look at the non generic function return value) with the generic overload GetAsync(), then the relational properties...
Hi pals, When doing the following query, the `NameEntityType` is still `null`: ``` public class NameEntity { public int Id { get; set; } public int NameEntityTypeId { get; set;...
1. Fixed method name violation. 2. Removed redundant code statements. 3. Removed unused `using`. 4. Removed redundant argument name. 5. Removed multiple enumerations happening code. 6. Converted to method group....
**Repro** Go here: https://sqlkata.com/playground/sqlserver Paste this: ``` bool? lol = true; bool lol2 = true; var query = new Query("Users").Where("lol", lol).Where("lol2", lol2); ``` SQL Server doesn't support true/false, only 0...
Is it possible to Include Multi-level `{ assess { assessno : 55, assessdet : { ..., fee : { id : 1, name: test } } } }` For example...
It does not seem to be possible to be explicit about the precedence when applying more than one combination. In the example below, without the additional parentheses the `INTERSECT` will...
