querybuilder

querybuilder copied to clipboard

Breaking change introduced in v2.2.3

1

A breaking change in the signature of `Query.AsInsert` was introduced in version 2.2.3. Signature that existed in v2.2.0: https://github.com/sqlkata/querybuilder/blob/v2.2.0/QueryBuilder/Query.Insert.cs#L43 ```csharp public Query AsInsert(IReadOnlyDictionary data, bool returnId = false) ``` How...

Sharparam

[Table] with nolock for each join tables

1

How can i add table hint for each join? var query = new Query().FromRaw("Users with (nolock)") .Join("Authors", "Authors.Id", "Posts.AuthorId") .Where("Id", 1) .Where("Status", "Active"); will be: SELECT * FROM Users with...

BalajiDharmaraj

Calling SelectRaw and passing in an empty string results in an extra trailing comma at the end of the SELECT right before the FROM

2

I'm on the fence about this being an issue but I didn't see it in closed or open issues so... worst-case y'all just close this. If I do a `.SelectRaw("")`...

jspinella

Add Async version of insert multiple rows

1

Hi, Is there any chance to get this method Async? ``` public static int Insert(this Query query, IEnumerable columns, IEnumerable valuesCollection, IDbTransaction transaction = null, int? timeout = null); ```...

NoamWe

Mixing `SUM` with other columns

6

It doesn't seem possible to have a `SUM` in a `SELECT` column list together with other columns (unless you hardcode it with `SelectRaw`), is this correct? Consider this query: ```sql...

Sharparam

.Include and .IncludeMany does not work with Guid keys in Postgres databases

5

Hi, When i use include method in postgres database with primary keys as guid i get the following error: `operator does not exist: uuid = text` I think the problem...

ldias91

Multiple/bulk update

2

Dapper can do bulk update. Following sample code is copied from [StackOverFlow](https://stackoverflow.com/questions/35134013/can-anybody-help-to-do-bulk-update-using-dapper-orm) ``` _connection.Execute(@"update employees set Name = @Name where Id = @Id", new List { new Employee{Age = 1,...

tulis

SQL syntax error while using Limit with UnionAll in MySQL

4

I'm using UnionAll with Limit and using MySQL compiler to get SqlResult, while I'm executing the command it is throwing SQL syntax error. Below is the code ` var query...

Sanjay85500

Can you do TEST for current "Include" or "IncludeMany"

5

Hi @ahmad-moussawi , Please can you do TEST for current "Include" or "IncludeMany" because it seem not to follow what is written in the READ.MD; ` var books = db.Query("Books")...

chrisgate

Perhaps I'm maybe just looking over it... but I'm getting this System.NotSupportedException exception for some reason when doing an insert. I don't do anything very exciting, it's just a simple...

higgs2