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
Currently SqlKata will try to apply a case insensitive operation, for WhereString operations, for example this query ``` var query = new Query("Car").WhereLike("Name", "AM"); ``` will get translated to ```...
This is my code: ``` public VORace Create(VORace x) { x.RaceId = null; int id = _queryFactory .Query("Race") .InsertGetId(x); x.RaceId = id; return x; } ``` this is my model:...
QueryFactory Select and Statement accept optional "commandType" supported by Dapper. Useful for Stored Procedure. Example ``` var parameters = new DynamicParameters(); parameters.Add("@param1", 2); parameters.Add("@param1out", dbType: DbType.Int32, direction: ParameterDirection.Output); var result...
Update data if certain conditions are met, insert the data otherwise. [ ] MySql: on duplicate key update [ ] SqlServer: #93 [ ] Postgres: (don't know)
Whenever a table has a column that contains a dot, it's escaped in way I don't want it to be escaped. Note: I am using the ```SqlServerCompiler``` class and have...
While creating a compiler to use with MSAccess, I found that I was having zero search results in all of my queries that used a 'where' statement. I tracked the...
Using SqlServerCompiler and running queries against SqlServer2017 (composing queries then feeding resulting queries as sql to EF context). When I compile a query using `.ForPage()`, it wraps my intended query...
Hello. SqlKata already have `WhereDatePart` method, but it doesn't have something like `WhereDateTrunc` method to compare truncated dates. For example we need to check if `Date` is current month: ```cs...
- Micro Improvement - Compiler.Wrap BenchmarkDotNet=v0.12.0, OS=Windows 10.0.18362 Intel Core i7-7820HQ CPU 2.90GHz (Kaby Lake), 1 CPU, 8 logical and 4 physical cores .NET Core SDK=3.0.100 [Host] : .NET Core...
A list of higher order functions that should be added to SqlKata. These features will be added as an extension project - [ ] SelectCase, WhereCase, HavingCase, and GroupByCase support...