コード例 #1
0
        public async Task Execute(DataTable dataToCopy, string destinationTableName)
        {
            _dbConnection.Init();
            var transaction = _dbConnection.BeginTransactionIfUsingInternalTransaction();

            try
            {
                var mapping     = _appContext.DataTableMappingCollection.GetMappingFor(dataToCopy.TableName);
                var columnNames = dataToCopy.Columns.Cast <DataColumn>()
                                  .Select(x => x.ColumnName)
                                  .ToArray();

                using var bulkCopyCommand = _dbConnection.CreateNewBulkCopyCommand((SqlTransaction)transaction);

                bulkCopyCommand.MapColumns(mapping, columnNames);
                await bulkCopyCommand.WriteToServerAsync(dataToCopy, destinationTableName);

                transaction.CommitIfUsingInternalTransaction(_appContext.IsUsingExternalTransaction);
                transaction.DisposeIfUsingInternalTransaction(_appContext.IsUsingExternalTransaction);
                _dbConnection.DisposeIfUsingInternalTransaction();
            }
            catch
            {
                transaction.Rollback();
                throw;
            }
        }
コード例 #2
0
        public async Task Execute <T>(IEnumerable <T> dataToProcess, string destinationTableName) where T : class
        {
            _dbConnection.Init();
            var transaction = _dbConnection.BeginTransactionIfUsingInternalTransaction();

            try
            {
                var type          = typeof(T);
                var mapping       = _appContext.ModelMappingCollection.GetMappingFor(type);
                var propertyNames = type.GetPublicPropertyNames();

                using var bulkCopyCommand = _dbConnection.CreateNewBulkCopyCommand((SqlTransaction)transaction);

                bulkCopyCommand.MapColumns(mapping, propertyNames);
                await bulkCopyCommand.WriteToServerAsync(dataToProcess, propertyNames, destinationTableName);

                transaction.CommitIfUsingInternalTransaction(_appContext.IsUsingExternalTransaction);
                transaction.DisposeIfUsingInternalTransaction(_appContext.IsUsingExternalTransaction);
                _dbConnection.DisposeIfUsingInternalTransaction();
            }
            catch
            {
                transaction.Rollback();
                throw;
            }
        }