/// <summary> /// 将一个 <see cref="IList"/> 批量插入到数据库中。 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="database">提供给当前插件的 <see cref="IDatabase"/> 对象。</param> /// <param name="list">要写入的数据列表。</param> /// <param name="tableName">要写入的数据表的名称。</param> /// <param name="batchSize">每批次写入的数据量。</param> /// <param name="completePercentage">已完成百分比的通知方法。</param> public async Task InsertAsync <T>(IDatabase database, IEnumerable <T> list, string tableName, int batchSize = 1000, Action <int> completePercentage = null, CancellationToken cancellationToken = default) { if (!BatcherChecker.CheckList(list, tableName)) { return; } await BatchInsertAsync(database, ToCollection(list), tableName, null, (map, command, r, item) => MapListItem <T>(database.Provider, map, (T)item, r, command.Parameters), batchSize, completePercentage); }
/// <summary> /// 将一个 <see cref="IList"/> 批量插入到数据库中。 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="database">提供给当前插件的 <see cref="IDatabase"/> 对象。</param> /// <param name="list">要写入的数据列表。</param> /// <param name="tableName">要写入的数据表的名称。</param> /// <param name="batchSize">每批次写入的数据量。</param> /// <param name="completePercentage">已完成百分比的通知方法。</param> public void Insert <T>(IDatabase database, IEnumerable <T> list, string tableName, int batchSize = 1000, Action <int> completePercentage = null) { if (!BatcherChecker.CheckList(list, tableName)) { return; } BatchInsert(database, ToCollection(list), tableName, null, (map, command, r, item) => MapListItem <T>(database.Provider, map, (T)item, r, command.Parameters), batchSize, completePercentage); }
/// <summary> /// 将一个 <see cref="IList"/> 批量插入到数据库中。 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="database">提供给当前插件的 <see cref="IDatabase"/> 对象。</param> /// <param name="list">要写入的数据列表。</param> /// <param name="tableName">要写入的数据表的名称。</param> /// <param name="batchSize">每批次写入的数据量。</param> /// <param name="completePercentage">已完成百分比的通知方法。</param> public void Insert <T>(IDatabase database, IEnumerable <T> list, string tableName, int batchSize = 1000, Action <int> completePercentage = null) { if (!BatcherChecker.CheckList(list, tableName)) { return; } Insert(database, list.ToDataTable(tableName), batchSize); }
/// <summary> /// 将一个 <see cref="IList"/> 批量插入到数据库中。 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="database">提供给当前插件的 <see cref="IDatabase"/> 对象。</param> /// <param name="list">要写入的数据列表。</param> /// <param name="tableName">要写入的数据表的名称。</param> /// <param name="batchSize">每批次写入的数据量。</param> /// <param name="completePercentage">已完成百分比的通知方法。</param> public void Insert <T>(IDatabase database, IEnumerable <T> list, string tableName, int batchSize = 1000, Action <int> completePercentage = null) { if (!BatcherChecker.CheckList(list, tableName)) { return; } var bulkType = CheckBulkCopy(database.Provider); if (bulkType != null) { BulkCopy(database, bulkType, list.ToDataTable(tableName), batchSize); } else { BatchInsert(database, ToCollection(list), tableName, null, batchSize, completePercentage); } }
/// <summary> /// 将一个 <see cref="IList"/> 批量插入到数据库中。 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="database">提供给当前插件的 <see cref="IDatabase"/> 对象。</param> /// <param name="list">要写入的数据列表。</param> /// <param name="tableName">要写入的数据表的名称。</param> /// <param name="batchSize">每批次写入的数据量。</param> /// <param name="completePercentage">已完成百分比的通知方法。</param> public async Task InsertAsync <T>(IDatabase database, IEnumerable <T> list, string tableName, int batchSize = 1000, Action <int> completePercentage = null, CancellationToken cancellationToken = default) { if (!BatcherChecker.CheckList(list, tableName)) { return; } var bulkType = CheckBulkCopy(database.Provider); if (bulkType != null) { BulkCopy(database, bulkType, list.ToDataTable(tableName), batchSize); } else { await BatchInsertAsync(database, ToCollection(list), tableName, null, batchSize, completePercentage, cancellationToken); } }