SqlBulkCopy in C#

SqlBulkCopy in C#

Lets you efficiently bulk load a SQL Server table with data from another source

 using (SqlBulkCopy bulkCopy =
 new SqlBulkCopy(connectionString, SqlBulkCopyOptions.KeepIdentity))
 {
      bulkCopy.DestinationTableName =
      "dbo.BulkCopyDemoMatchingColumns";
     try
     {
         // Write from the source to the destination may be table name or datatable.
         bulkCopy.WriteToServer(dt);
     }
    catch (Exception ex)
    {
          Console.WriteLine(ex.Message);
    }
    finally
    {
       
    }
}