DEV Community

Bulk Insert With Dapper - with Table Type Parameter

Zoltan Halasz on November 29, 2019

One of my favorite online trainers, Tim Corey, introduced Dapper for me two years ago. It was only the last week when I stumbled upon his advanced ...
Collapse
 
mikependon profile image
Mike Pendon (Zym)

Great post! Btw, you are not doing a real bulk-insert operation here. What you are doing is a batch-insert through UDT that accepts the list of the data entities. In which, there is a performance flaw of INSERT-SELECT when compared to using the BCP or SqlBulkCopy class. In anyway, this is a much better approach when compared to your first post related to this. Cheers!

Collapse
 
zoltanhalasz profile image
Zoltan Halasz

It is more than sufficient for my purposes. Thanks for the remark!

Collapse
 
zoltanhalasz profile image
Zoltan Halasz

Thank you, I appreciate!