createManyValues method

Future<MssqlCreateManyResult<TRow>> createManyValues(
  1. List<MssqlWriteAssignments> rows, {
  2. MssqlCreateManyStrategy strategy = MssqlCreateManyStrategy.insertValues,
  3. MssqlBulkOptions bulk = const MssqlBulkOptions(),
  4. bool atomic = true,
  5. bool returnRows = true,
})

Batched insert of rows. Atomic by default; never switches to BCP.

strategy is the caller's choice. Mapped stored rows need a key or identity; BCP refuses returnRows: true.

Implementation

Future<MssqlCreateManyResult<TRow>> createManyValues(
  List<MssqlWriteAssignments> rows, {
  MssqlCreateManyStrategy strategy = MssqlCreateManyStrategy.insertValues,
  MssqlBulkOptions bulk = const MssqlBulkOptions(),
  bool atomic = true,
  bool returnRows = true,
}) async {
  final dialect = await _resolvedDialect();
  return _bulkWriter(dialect).createMany(
    rows,
    strategy: strategy,
    bulk: bulk,
    atomic: atomic,
    returnRows: returnRows,
  );
}