Boris Djurdjevic comments

Results 267 comments of


                                            Boris Djurdjevic

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

The ON CONFLICT Clause is in `SqlQueryBuilderSqlite` in method `InsertIntoTable` which is called from `GetSqliteCommand` in Adapter. So it's more likely that exception is thrown there at `command.Prepare();` or in...

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

You don't need _PropertiesToIncludeOnUpdate_, just set **_UpdateByProperties_** `var bulkConfig = new BulkConfig { UpdateByProperties = new List { nameof(Customer.Name) } };`

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

I can confirm the bug but don't have the solution at the moment

BulkRead with static BulkConfig only fetches data on first attempt

For **BulkRead** _PropertiesToInclude_ is set at one point internally and it remains that way. For the moment you could just reset it to null after each read: `bulkConfig.PropertiesToInclude = null;`...

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

Aside from nesting Bulk ops into a transaction scope, there is also Underlying-Conn/Tran. Note in ReadMe: `Config also has DelegateFunc for setting Underlying-Connection/Transaction, e.g. in UnderlyingTest.`

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

I think your suggestion can be added, will consider it.

BulkRead using TPT (table-per-type)

Not directly, you could try with 2 BulkRead similar to 2 BulkInsert done in `EFCore.BulkExtensions.Tests EFCoreBulkTestAtypical.TablePerTypeInsertTest` then join in memory properties of list to another.

BulkRead using TPT (table-per-type)

Will consider it.

merge vs insert into in a insert only scenario

Will consider it.

bandwith problem with SetOutputIdentity = true

Redundant Columns could be removed (leaving only Identity, TimeStamp, Computed, DefaultVal.) from _SelectFromOutputTable_ method that makes Query text, but the problem is that used reader `context.Set().FromSqlRaw(sqlQuery)` needs all columns in...