19 December 2011

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
    {
       
    }
}

1 comment:

  1. Hi.. this is not loading all recored into Sql table..im trying to load 1 lakh record.. but it s loading only 20000

    ReplyDelete

Comments Welcome