title: Violation of UNIQUE KEY Contstraints - Cannot insert duplicate key
body: <p>I am pulling out my hair over here.  I have a table that has a UNIQUE Key (IX_tblTable) and the unique key is on a column Number.  I am parsing some data from the web and storing it in the table.  My latest collection of data from the web contains number <strong>THAT ARE NOT CONTAINED IN THE DATABASE</strong>.  so I am getting data from the site and all of the data I am getting in unique, there are no duplicates and the numbers in the list that is returned are not in the database.</p>
  
  <p>I keep getting this error everytime I try to update the database, what is the best way to trap the error to see which number is throwing the error.  I am storing everything that comes back in an object list and when it is done running I have 131 records that need to be inserted and I can not see which one is throwing this error.  What is the bast way to trap it?</p>
  
  <p>EDIT: I am using sql server 2005, wirtting in C# and using Linq2SQL.  I can not post any c# code at this time for proprietary reasons...</p>