title: How to use SqlBulkCopyColumnMappingCollection?
body: <p>I want to make one SqlBulkCopy method that I can use for all my bulk inserts by passing in specific data through the parameters.</p>
  
  <p>Now I need to do mapping on some of them. I don't know how to make a SqlBulkCopyColumnMappingCollection since that was my plan to pass in the mapping collection in and use it. However I don't know how to make it. I can't make a new object of it.</p>
  
  <p>This is what I have now. How can I add it do mapping put pass it in?</p>
  
  <pre><code>public void BatchBulkCopy(DataTable dataTable, string DestinationTbl, int batchSize)
  {
      // Get the DataTable 
      DataTable dtInsertRows = dataTable;
  
      using (SqlBulkCopy sbc = new SqlBulkCopy(connectionString, SqlBulkCopyOptions.KeepIdentity))
      {
          sbc.DestinationTableName = DestinationTbl;
  
          // Number of records to be processed in one go
          sbc.BatchSize = batchSize;
  
          // Finally write to server
          sbc.WriteToServer(dtInsertRows);
      }
  }
  </code></pre>