EFCore.BulkExtensions

EFCore.BulkExtensions copied to clipboard

Upsert ignores custom conversions

1

Does `EFCore.BulkExntensions` ignore custom conversions? I receive the exception while try to use `BulkInsertOrUpdateAsync` with PostgreSQL: `System.InvalidCastException: Can't write CLR type NodaTime.TimeZones.CachedDateTimeZone with handler type TextHandler` Conversion: ``` builder.Property(p =>...

yury-sch

BulkInsertOrUpdateOrDelete: bulkConfig.StatsInfo.StatsNumberInserted is wrong if nothing was updated

1

I'm using EFCore.BulkExtensions v6.0.7 and initialize my table on a MS SQL server with ``` context.Students.BatchDelete(); context.Students.Add(new Student() { StudentId = 1, Name = "John Doe" }); context.SaveChanges(); ``` Later...

michull

SQLite - ON CONFLICT clause does not match any PRIMARY KEY or UNIQUE constraint

7

I am using 3.2.5 in UWP app with SQLite. I cannot upgrade to latest version due to .NET Standard 2.1 is not fully supported to UWP so we cannot upgrade...

Arslan007

Insert if not Exist based on property compare and fetch identity if exists

5

This is a question. I'm using SQLite DB and trying to achieve the following. Any idea how to achieve (or) nearly achieve such a case? ``` var customers = new...

Gopichandar

BulkRead with static BulkConfig only fetches data on first attempt

2

Just a question. While testing `BulkRead` I noticed that if I use a **static** `BulkConfig` it only fetches the data the first time. All successive attempts while app was running...

qvsmith

Sqlite Exception: System.InvalidOperationException: SqliteConnection does not support nested transactions

4

I have a somewhat special use case in my EFCore application. When a DBContext is newed up i need it to re-use a SqliteConnection object from my own application connection...

d79ima

BulkRead using TPT (table-per-type)

3

Is it possible to do a BulkRead if using TPT? https://docs.microsoft.com/en-us/ef/core/modeling/inheritance#table-per-type-configuration

Ameen-Alqattow

merge vs insert into in a insert only scenario

1

hello in my case i need to be able to handle multiple large bulk insert in parallel after multiple test what i have seen is the merge pattern is slower...

Spirch

bandwith problem with SetOutputIdentity = true

3

when the `SetOutputIdentity = true` is set, it create a lot of traffic over the wire. My understanding there is a select * being done on the output table to...

Spirch

making everything less chatty

1

for every table there is seven EF queries sent, in a case of `SetOutputIdentity = true` which include `IncludeGraph = true` 1. create table 2. create output table 3. alter...

Spirch