LINQ To DB allows you to specify one of four insert methods (or three, as Default is not an actual method): Task BulkCopyAsync(this ITable table, IAsyncEnumerable source, CancellationToken cancellationToken = default) Task BulkCopyAsync(this ITable table, IEnumerable source, CancellationToken cancellationToken = default)
Task BulkCopyAsync(this DataConnection dataConnection, BulkCopyOptions options, IAsyncEnumerable source, CancellationToken cancellationToken = default) A few of the asynchronous signatures are listed below: Task BulkCopyAsync(this DataConnection dataConnection, BulkCopyOptions options, IEnumerable source, CancellationToken cancellationToken = default) Each method accepts an optional CancellationToken parameter to cancel the bulk copy operation. Net Standard, one accepting an IAsyncEnumerable. In addition, there are two asynchronous methods for each of the methods listed above one accepting an IEnumerable, and for. DataConnectionExtensions.csīulkCopyRowsCopied BulkCopy(this DataConnection dataConnection, BulkCopyOptions options, IEnumerable source)īulkCopyRowsCopied BulkCopy(this DataConnection dataConnection, int maxBatchSize, IEnumerable source)īulkCopyRowsCopied BulkCopy(this DataConnection dataConnection, IEnumerable source)īulkCopyRowsCopied BulkCopy(this ITable table, BulkCopyOptions options, IEnumerable source)īulkCopyRowsCopied BulkCopy(this ITable table, int maxBatchSize, IEnumerable source)īulkCopyRowsCopied BulkCopy(this ITable table, IEnumerable source) How insert operations are performed internally depends on the level of provider support and the provided options. There are several overrides, but all they do the same thing - take data and operation options, then perform inserts and return operation status. To leverage the complexity of work with this operation, LINQ To DB provides a BulkCopy method. The downside of this method is that each server has its own view on how this functionality should work there is no standard interface for it.
Some database servers provide functionality to quickly insert large amounts of data into a table.
0 kommentar(er)
