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 have a simple C# record, which I want to insert into the database using InsertAsync method of SqlKata. The insert fails with the following exception: ``` The member p0...
There are places where the `parameterPlaceholder` variable isn't used and the `?` (question mark) is hardcoded in code. This prevents the redefinition of the `parameterPlaceholder` to another value. #### Practical...
This fixes two tests that fail on machines with non English locales because of how comma separators are rendered.
Currently, SqlKata allows consumers to quote identifiers only within `?Raw` methods. Due to that when working with identifiers which need to be quoted (whether being keywords or due to casing)...
XML Tags to clarify usage of Opening/Closing Identifiers Unit Test for `Compiler.WrapIdentifiers` and `ReplaceIdentifierUnlessEscaped` (the latter was just renamed according to the method name) Unit tests written to showcase issue...
Bumps [Newtonsoft.Json](https://github.com/JamesNK/Newtonsoft.Json) from 11.0.2 to 13.0.1. Release notes Sourced from Newtonsoft.Json's releases. 13.0.1 New feature - Add JsonSelectSettings with configuration for a regex timeout Change - Remove portable assemblies from...
![dependabot[bot] avatar](https://avatars.githubusercontent.com/in/29110?v=4 "dependabot[bot] avatar"){kind=avatar}
It support like that to explain query. ```csharp var explain = query.Clone().SetExplain().Get(); ``` Fix #571 Uncomplated tasks - [ ] Add more test to explain sql generate - [ ]...
Hi I made changes for query like scroll for virtual scroll or infinite scroll presentation
This is a replacement PR for this older branch: [issue-192](https://github.com/sqlkata/querybuilder/tree/issue-192) I compared the test case that was in the old branch, my tests are equivalent. The generated SQL is slightly...
