/// <summary> /// Bulk Insert with a given destination name /// </summary> /// <typeparam name="T"></typeparam> /// <param name="db"></param> /// <param name="tableName"></param> /// <param name="dt"></param> /// <param name="tran"></param> public static void BulkInsert <T>(this SqlConnection db, string tableName, List <T> dt, SqlTransaction tran = null) { using (var sbc = new SqlBulkInsert(db, tran)) { sbc.BulkInsert(tableName, dt); } }
/// <summary> /// 批量插入数据 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="db"></param> /// <param name="dt"></param> public static void BulkInsert <T>(this SqlConnection db, List <T> dt) { var tableName = typeof(T).Name; using (var sbc = new SqlBulkInsert(db)) { sbc.BulkInsert(tableName, dt); } }