FlexLabs.Upsert

FlexLabs.Upsert copied to clipboard

match columns have to be properties of the TEntity class

1

Getting this error when trying to use the library ``` var p = new Product() { ProductName = request.ProductName, ProductDescription = request.ProductDescription }; await _context.Product.Upsert(p) .On(w => w.Id == request.Id)...

mweel1

https://github.com/artiomchi/FlexLabs.Upsert/blob/152a890b21566dc617d13032df2404fd07d5c29c/src/FlexLabs.EntityFrameworkCore.Upsert/Runners/RelationalUpsertCommandRunner.cs#L170 According to this line, allow insert when property is not set as value generated or save behavior on update. I think it should be ``` var allowInserts = p.ValueGenerated...

Kation

Upsert on conflict - Alias instead of exclude

3

I currently have a problem with Upsert not updating my entries in database. ``` await _context.Articles.UpsertRange(articles) .On(x => x.Id) .WhenMatched(x => new Article() { AccessId = x.AccessId }) .AllowIdentityMatch() .RunAsync(cancellationToken);...

Inexad

I see we have this code in the UpsertCommandBuilder to build the command based on their runners. Is there any way we can pass these runners or replace them with...

vamsidogiparthi

Add a method that returns the resulting SQL query for debugging purposes

1

It would be great if there is a method on `UpsertCommandBuilder` that just returns the SQL query. EF Core supports a similar method: https://learn.microsoft.com/en-us/dotnet/api/microsoft.entityframeworkcore.entityframeworkqueryableextensions.toquerystring?view=efcore-7.0 If you agree with the concept,...

mhmd-azeez

Hello! How could a domain be implemented where the properties are set to private? Here is an example of the same: ` public class People { public Guid Id {...

marcelokrol

I suggest a fix in this section [here](https://github.com/artiomchi/FlexLabs.Upsert/blob/152a890b21566dc617d13032df2404fd07d5c29c/src/FlexLabs.EntityFrameworkCore.Upsert/Runners/RelationalUpsertCommandRunner.cs#L192) it should look like so: ```C# while (entitiesProcessed < newEntities.Length) { var arguments = new List(); var argumentCount = 0; if (updateExpressions...

Red1408192