FlexLabs.Upsert
FlexLabs.Upsert copied to clipboard
artiomchi
FlexLabs.Upsert is a library that brings UPSERT functionality to common database providers for Entity Framework in their respective native SQL syntax
Hello! Is there way to use postgres FOR UPDATE or SKIP LOCKED commands?
- Add CommandRunner that generates `MERGE INTO` query for Oracle - All integration tests passing - All unit tests passing
My postgresql database has: ``` CREATE TABLE events ( ... error_details JSONB NULL ... ) ``` In my model i have: ``` modelBuilder.Entity().OwnsOne(x => x.ErrorDetails, builder => builder.ToJson("error_details")); ``` Which...
Just hit an invalid match exception 6.0.2. Here's the message: FlexLabs.EntityFrameworkCore.Upsert.InvalidMatchColumnsException: 'Using autogenerated / identity keys as the upsert match excession is not supported. Pick a non generated unique key....
I suggest a fix in this section [here](https://github.com/artiomchi/FlexLabs.Upsert/blob/152a890b21566dc617d13032df2404fd07d5c29c/src/FlexLabs.EntityFrameworkCore.Upsert/Runners/RelationalUpsertCommandRunner.cs#L192) I recently got stucked by the really unlucky scenario where the parameters count can exceed the number allowed by sql server Related...
An exception "Database provider not supported yet" is thrown when trying to upsert a Oracle database table
First of all, let me start by saying this is a great library which provides an elegant solution to a common requirement. I came in to submit an issue I'm...
I have entity  and Upser method  and have CS9035 error in build time  
``` using System.ComponentModel.DataAnnotations; using System.ComponentModel.DataAnnotations.Schema; using DotNet.Testcontainers.Builders; using DotNet.Testcontainers.Configurations; using DotNet.Testcontainers.Containers; using Microsoft.EntityFrameworkCore; using Newtonsoft.Json; var _dbContainer = new TestcontainersBuilder() .WithDatabase(new PostgreSqlTestcontainerConfiguration { Database = "db", Username = "postgres", Password...
In my case, i want to make an upsert in place of ExecuteUpdateAsync (only usable for an update ``` await _dbContext.dbSet1 .Include(d=> d.W .Where(cw => cw.Id == wInstance.Id)) .Where(d=>d.Id ==...
