title: How can I track failed CRUD rows when using bulk insert/update/delete?
body: <p>Im trying to figure out how I can do bulk operations on a table in SQL datbase where I want to be able to handle failed rows. </p>
  
  <p>Let's say I do a bulk insert of 10 rows into a table and row number 5 has some faulty data and can't be inserted. I then want the 9 other rows to be inserted but in some way be able to get the 1 row that coulden't be inserted in return so I can store this row in some place for later error handling.</p>
  
  <p>It would be great if I could use some nuget package for C# programming.</p>