querybuilder

querybuilder copied to clipboard

I want to be able to decrement a value in the database for which `AsDecrement` would be perfect, but I want to ensure it doesn't get decremented below zero. It...

mattbrailsford

Updated example for Includes

5

Quick question around is there an updated example for the Includes function? The documentation shows the function taking 1 parameter (which i assume is a query for the table you...

Reddevildragg

[SQL Server] Error inserting varbinary(max) with NULL value

3

I currently use Dapper and SqlKata for the data access in my application. My entity class contains a `byte[]` which should be persisted in the database and might contain NULL...

danehnert

I want to register a singleton instance of SqlServerCompiler in my IoC container and then inject this instance into any services that need it, rather than having those services create...

pmarflee

TableAttribute introduction

1

Would be nice to introduce `TableAttribute`. Usage: ``` [Table("core_users")] public class User { [Key] public int Id { get; set; } public string UserName { get; set; } // Default...

fairking

Hi, I used this code to update a Unicode (nvarchar) field in the database. but instead of Unicode characters, it saves the question mark (like this: ????? ????) into the...

mojtaba-yekta

Delete with joins

4

Pull request to rebase this old branch onto master Related to #182

mathijs-dumon

OracleCompiler generates invalid multiple row insert

5

Given the query ```cs db.Query(string table).AsInsert(IEnumerable columns, IEnumerable valuesCollection, bool returnId = false); ``` Compiles to invalid sql for oracle ```sql INSERT INTO "mtable" ("one", "two") VALUES (3348, 0), (3348,...

ceastwood

Does the extension method InsertGetId works for Oracle?

5

Hello, thanks for developing this project. Does the extension method InsertGetId works for Oracle?

frenkhub

postgres last inserted id : "RETURNING id" vs "lastval()"

6

"RETURNING id" is more safe and reliable "lastval()" can cause some issues with triggers https://www.postgresql.org/docs/current/dml-returning.html https://github.com/sqlkata/querybuilder/blob/master/QueryBuilder/Compilers/PostgresCompiler.cs https://stackoverflow.com/questions/17819001/postgres-not-returning-lastval-properly https://stackoverflow.com/questions/2944297/postgresql-function-for-last-inserted-id

abdeldjalil-fellah