C# 使用SqlBulk批量插入数据

 

使用SqlBulk

连接字符串：<add name="bulkConntection" connectionString="data source=127.0.0.1;initial catalog=dbname;user id=sa;password=root;"/>

private static string connstring = ConfigurationManager.ConnectionStrings["bulkConntection"].ToString();

List<WkOrderDetail> detail = ModelConvertHelper<WkOrderDetail>.ConvertToModel(table).ToList();
                
using (SqlConnection conn = new SqlConnection(connstring))
{
    conn.Open();
    SqlTransaction sqlTran = conn.BeginTransaction();
    using (SqlBulkCopy bcp = new SqlBulkCopy(conn, SqlBulkCopyOptions.Default, sqlTran))
    {
　　　　//表名
        bcp.DestinationTableName = "WkOrderDetail";
        try
        {
            //实体集合
            var dt = DataTableHelper.ToDataTable(detail);
            bcp.WriteToServer(dt);
            sqlTran.Commit();
        }
        catch (Exception e)
        {
            sqlTran.Rollback();
        }
        finally
        {
            sqlTran.Dispose();
        }
    }
}