internal async Task PersistAsync(IDbTransaction transaction, CancellationToken cancellationToken) { foreach (var masterdata in MasterDataDtos) { var command = new CommandDefinition(SqlQueries.Delete_MasterData, masterdata, transaction, cancellationToken: cancellationToken); await transaction.Connection.ExecuteAsync(command); } await transaction.BulkInsertAsync(MasterDataDtos, cancellationToken); await transaction.BulkInsertAsync(AttributeDtos, cancellationToken); await transaction.BulkInsertAsync(FieldDtos, cancellationToken); await transaction.BulkInsertAsync(HierarchyDtos, cancellationToken); }
private static async Task StoreStandardBusinessHeader(StandardBusinessHeader header, int requestId, IDbTransaction transaction, CancellationToken cancellationToken) { if (header == default) { return; } var headerDto = StandardHeaderDto.Create(header, requestId); var contacts = header.ContactInformations.Select((x, i) => ContactInformationDto.Create(x, requestId, i)); await transaction.InsertAsync(headerDto, cancellationToken); await transaction.BulkInsertAsync(contacts, cancellationToken); }
internal async Task PersistAsync(IDbTransaction transaction, CancellationToken cancellationToken) { await transaction.BulkInsertAsync(Events, cancellationToken); await transaction.BulkInsertAsync(Epcs, cancellationToken); await transaction.BulkInsertAsync(SourceDests, cancellationToken); await transaction.BulkInsertAsync(Transactions, cancellationToken); await transaction.BulkInsertAsync(CustomFields, cancellationToken); await transaction.BulkInsertAsync(CorrectiveIds, cancellationToken); }