querybuilder
querybuilder copied to clipboard
SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird
Better pagination performance
In this PR, I added dapper multimapping funcionality. This is really useful for one to many relathionship. Regards
Implements an argument in Insert/Update-clauses related functions to allow returning columns directly through SQL **Compatibility:** - [x] PostgreSQL - [x] MSSQL A generic function was created to allow RDBMS-specific compilers...
I was happily making some other contributions to the codebase when I decided to try testing for SQL Injection vulnerabilities. I was dismayed when all my single quotes were not...
While Insert method has several overloads: object, dictionary, columns + values, etc, there is only one overload of InsertGetId - with object. For my project it very crucial to have...
CacheDictionaryProperties wasn't being used.... should it? There was an error if the Key attribute and Column attribute were both on a property. Since Key inherits from Column `var colAttr =...
OrderBy's and Limit's are should be after UNION
There exist some JSON specific operations in PostgreSQL that begin with the questionmark: https://www.postgresql.org/docs/9.5/functions-json.html Currently it is only possible to write queries that involve JSON operations in a `RawQuery`. But...