title: How to return result after bulkCopy.WriteToServer
body: <p><strong>UPDATE</strong> based on accepted answer:</p>
  
  <pre><code>bool success = false;
  using (var bulkCopy = new SqlBulkCopy(connection)) //using!
  {
      connection.Open();
  
      //explicit isolation level is best-practice
      using (var tran = connection.BeginTransaction(IsolationLevel.ReadCommitted))
      {
          bulkCopy.DestinationTableName = "table";
          bulkCopy.ColumnMappings...
  
          using (var dataReader = new ObjectDataReader&lt;SomeObject&gt;(paths))
          {            
              bulkCopy.WriteToServer(dataReader);
              success = true;
          }
  
          tran.Commit(); //commit, will not be called if exception escapes
      }
  }
  return success;
  </code></pre>
  
  <p>I use <code>BulkCopy</code> class for large insert and it works fine.<br/>
  After execute <code>WriteToServer</code> and saving data to database <br/>I wan't to know are all data saved successfully so I can return <code>true/false</code> because I need to save all or nothing?</p>
  
  <pre><code>    var bulkCopy = new SqlBulkCopy(connection);
  
      bulkCopy.DestinationTableName = "table";
  
      bulkCopy.ColumnMappings...
  
      using (var dataReader = new ObjectDataReader&lt;SomeObject&gt;(paths))
      {
          try
          {
          bulkCopy.WriteToServer(dataReader);
          }
          catch(Exception ex){ ... }    
  }
  </code></pre>