Checking for existing records

Nov 6, 2014 at 2:22 PM
Is there a way to check if inserted data has existing entities and skip them?
Nov 11, 2014 at 8:26 PM
Hi

Doesn't exist in the original BulkInsert without the EntityFramework and I don't think exist something like checking existing records in High Level.
Unless you do it before the BulkInsert. However you can do it at level of DB.

I created a Trigger with INSTEAD OF INSERT and use inside MERGE statement.

But don't forget add the parameter SqlBulkCopyOptions.FireTriggers in the SqlBulkCopy.

I hope this helps.

Ivan Paniagua Monroy
MCP-MCSD-MCTS-MCSA
http://ivanpaniagua.wordpress.com/