public void UpdateManyItems() { IEnumerable <BulkUpdateItem> data = GetItems(); using (var reader = new EnumerableDataReader <BulkUpdateItem>(data, new string[] { "Id", "Name" })) { using (var bulkUpdate = new MsAccessBulkUpdate("connection string")) { bulkUpdate.Update(reader); } } }
private void DataTableBulkUpdateCore(OleDbConnection cn) { DataTable expectedData = CreateExpectedData(); using (var bulkUpdate = new MsAccessBulkUpdate(cn)) { bulkUpdate.DestinationTableName = TableName; bulkUpdate.PrimaryKeyColumn = PrimaryKeyColumn; bulkUpdate.Update(expectedData); } DataTable actualData = LoadData(cn); MsAccessBulkHelper.CompareTables(actualData, expectedData); }
private void IBulkActionDataReaderBulkUpdateCore( OleDbConnection cn, DataTable expectedData, Action <IDbConnection, IDbTransaction, string> action) { using (IBulkActionDataReader reader = CreateDataReaderForUpdate()) using (var bulkUpdate = new MsAccessBulkUpdate(cn)) { bulkUpdate.DestinationTableName = TableName; bulkUpdate.PrimaryKeyColumn = PrimaryKeyColumn; bulkUpdate.TempTableAction = action; bulkUpdate.Update(reader); } DataTable actualData = LoadData(cn); MsAccessBulkHelper.CompareTables(actualData, expectedData); }
public void BulkUpdateDataFromIDataReaderIntoMdbSynchronouslyWithoutDeadLock() { AsyncContext.Run(() => { Helpers.SkipTestIfJetProviderNotAvailable(); using (var helper = CreateHelper(ProviderType.Jet, MdbFileName)) { DataTable expectedData = CreateExpectedData(); using (IBulkActionDataReader reader = CreateDataReaderForUpdate()) using (var bulkUpdate = new MsAccessBulkUpdate(helper.Connection)) { bulkUpdate.DestinationTableName = TableName; bulkUpdate.PrimaryKeyColumn = PrimaryKeyColumn; bulkUpdate.Update(reader); } DataTable actualData = LoadData(helper.Connection); MsAccessBulkHelper.CompareTables(actualData, expectedData); } }); }