Open GeorgyRezchikov opened 3 years ago
Hello @GeorgyRezchikov ,
Thank you for reporting,
We will look if that's possible to do something or not.
At first sight, the issue happens due to case sensibility when selecting the column. The alias "Id"
is used instead of the column name id
. I'm not sure if we are aware of the alias name used for the primary key but we will look at it.
Meanwhile, you already know how to make it works.
Best Regards,
Jon
Sponsorship Help us improve this library
Performance Libraries
context.BulkInsert(list, options => options.BatchSize = 1000);
Entity Framework Extensions • Bulk Operations • Dapper Plus
Runtime Evaluation
Eval.Execute("x + y", new {x = 1, y = 2}); // return 3
C# Eval Function • SQL Eval Function
Hello @GeorgyRezchikov ,
Unfortunately, for now, we choose to not yet support this scenario due to the complexity (we didn't find any good solution in the delay we had)
However, we will certainly try again in the future since that's a scenario we would like to support.
Here is what to include in your request to make sure we implement a solution as quickly as possible.
Description
I am trying to update multiple fields using a condition
Generated SQL query:
I am trying to do a projection to reduce data reading
Generated SQL query:
Exception
I receive an error like below.
42703: column b.id does not exist
Is it possible to somehow reduce the reading of data?
Further technical details