phongnguyend/entityframeworkcore.sqlserver.simplebulks

Very simple .net library that supports bulk insert (retain client populated Ids or return db generated Ids), bulk update, bulk delete and bulk merge operations. Lambda Expression is supported.

entityframeworkcore.sqlserver.simplebulks's Issues

Support Merging

Support Composite Key

Does the merge statement need the HOLDLOCK hint?

I have seen other solutions use the ‘WITH (HOLDLOCK)‘ hint when generating the merge statement.

Is this hint missing from your solution?

See https://weblogs.sqlteam.com/dang/2009/01/31/upsert-race-condition-with-merge/

Also, do you drop the temporary table when you are finished with it as I could not see this code.

Upgrade .Net 5

Upgrade to .Net Core 3

Get the generated identity value for BulkMerge

First I want to thank you for this excellent project. It works great and it is really fast.

The only thing I'd love to have is to be able to get the entities updated with the PK when I call BulkMerge. With BulkInsert I can get the PK using the options.KeepIdentity = false but there is no equivalent property for BulkMerge. It would be awesome if that can be added.

Benchmark about.

Is there any performance comparison between datatable and zlib libraries?

Inferring Table Name from Type

[BulkInsert] Returning Database Generated Ids

Support working with ADO.NET, Dapper

BulkInsert - Error Cannot access destination table '[SchemaName.TableName]' (Invalid square brackets)

Hi! Excelent works with your library! but when execute a BulkInsert basic without parameters....
I get this error "Error Cannot access destination table '[SchemaName.TableName]'" but the schema and table name exists.
I debug your code and the the problem is the "[]" brackets around the [SchemaName.TableName], see the next example:

SELECT * FROM [vad.VadeResults] --> It is not work (Current Behavior)

SELECT * FROM vad.VadeResults --> It's Works (Expected)
SELECT * FROM [vad].[VadeResults] --> It's Works (Expected Better)

I thinks that the expression to complete the "DestinationTableName" property must be something like that [SchemaName].[TableName] to be compatible with differents schemas, and also avoid tables with reserved words...

As Workaround, I remove the brackets concatenation from this code, and works fine:

Thanks in advanced!

[Bulk Insert] Keep Client Id