can BulkInsert support my custom ValueGenerator for Id column

borisdj / EFCore.BulkExtensions

Entity Framework EF Core efcore Bulk Batch Extensions with BulkCopy in .Net for Insert Update Delete Read (CRUD), Truncate and SaveChanges operations on SQL Server, PostgreSQL, MySQL, SQLite

https://codis.tech/efcorebulk

Other

3.6k stars 580 forks source link

can BulkInsert support my custom ValueGenerator for Id column #1512

Open tlb-abdulqadir opened 2 months ago

tlb-abdulqadir commented 2 months ago

I have a custom value generator for my ID column in one of the entity. Something like:

select available_id from available_id_table where id  nextval('custom_sequence')

Would it be possible to respect this using BulkInsert operation?

tlb-abdulqadir commented 2 months ago

I was thinking and think it'll be easier to it this way:

to insert X rows, I get X Ids first from the sequence
then, i assign those IDs explicitly before calling BulkInsert