title: Behavior of SqlBulkCopy with unique identity columns in database
body: <p>I am facing and issue while inserting data in database. I used a column as unique identity to prevent duplication. When i insert data from excel file to database with sqlbulkcopy, data inserts correctly but when i try to test and insert the same data, sqlbulkcopy commit's the transaction without any error and after this i checked my database there is no update in existing record and no duplicate values.</p>
  
  <p>My question is Why SqlBulkCopy committing transaction without throwing unique identity error? </p>