title: FileHelpers and SQL Insert with SqlServerStorage class ---How to show errors
body: <p>I am using the FileHelpers libraries to upload a CSV file to SQL Server.  I would like to present the user with a list of records which could not be uploaded do to errors.  I am setting the ErrorMode of the SqlServerStorage class to SaveAndContinue, however the InsertRecords method still throws an exception when one of the records violates a foriegn key constraint.  Is there a way to save this error and continue with the insert?  </p>
  
  <pre><code>SqlServerStorage storage = new SqlServerStorage(typeof(RouteRecord),ConfigurationManager.ConnectionStrings["DBConnString"].ConnectionString);
  storage.ErrorManager.ErrorMode = FileHelpers.ErrorMode.SaveAndContinue;
  storage.InsertRecords((RouteRecord[])Session["successfulRecordArray"]);
  </code></pre>
  
  <p>Thanks. </p>