public void TestMicrosoftSqlConnectionBaseRepositoryBulkDeleteForEntitiesWithPrimaryKeys()
{
// Setup
var tables = Helper.CreateBulkOperationIdentityTables(10);
using (var repository = new BulkOperationIdentityTableRepository())
{
// Act
repository.InsertAll(tables);
// Setup
var primaryKeys = tables.Select(e => (object)e.Id);
// Act
var bulkDeleteResult = repository.BulkDelete(primaryKeys);
// Assert
Assert.AreEqual(tables.Count, bulkDeleteResult);
// Act
var countResult = repository.CountAll();
// Assert
Assert.AreEqual(0, countResult);
}
}
public void TestMicrosoftSqlConnectionDbRepositoryBulkDeleteForTableNameEntitiesWithQualifiers()
{
// Setup
var tables = Helper.CreateBulkOperationIdentityTables(10);
using (var repository = new BulkOperationIdentityTableRepository())
{
// Act
repository.InsertAll(tables);
// Act
var bulkDeleteResult = repository.BulkDelete(ClassMappedNameCache.Get <BulkOperationIdentityTable>(),
tables,
qualifiers: e => new { e.RowGuid, e.ColumnInt });
// Assert
Assert.AreEqual(tables.Count, bulkDeleteResult);
// Act
var countResult = repository.CountAll();
// Assert
Assert.AreEqual(0, countResult);
}
}
public void TestMicrosoftSqlConnectionDbRepositoryBulkDeleteForTableNameEntitiesWithUsePhysicalPseudoTempTable()
{
// Setup
var tables = Helper.CreateBulkOperationIdentityTables(10);
using (var repository = new BulkOperationIdentityTableRepository())
{
// Act
repository.InsertAll(tables);
// Act
var bulkDeleteResult = repository.BulkDelete(ClassMappedNameCache.Get <BulkOperationIdentityTable>(),
tables,
usePhysicalPseudoTempTable: true);
// Assert
Assert.AreEqual(tables.Count, bulkDeleteResult);
// Act
var countResult = repository.CountAll();
// Assert
Assert.AreEqual(0, countResult);
}
}
public void TestMicrosoftSqlConnectionBaseRepositoryBulkDeleteForEntitiesWithMappings()
{
// Setup
var tables = Helper.CreateBulkOperationIdentityTables(10);
var mappings = new List <BulkInsertMapItem>();
// Add the mappings
mappings.Add(new BulkInsertMapItem(nameof(BulkOperationIdentityTable.ColumnBit), nameof(BulkOperationIdentityTable.ColumnBit)));
mappings.Add(new BulkInsertMapItem(nameof(BulkOperationIdentityTable.ColumnDateTime), nameof(BulkOperationIdentityTable.ColumnDateTime)));
mappings.Add(new BulkInsertMapItem(nameof(BulkOperationIdentityTable.ColumnDateTime2), nameof(BulkOperationIdentityTable.ColumnDateTime2)));
mappings.Add(new BulkInsertMapItem(nameof(BulkOperationIdentityTable.ColumnDecimal), nameof(BulkOperationIdentityTable.ColumnDecimal)));
mappings.Add(new BulkInsertMapItem(nameof(BulkOperationIdentityTable.ColumnFloat), nameof(BulkOperationIdentityTable.ColumnFloat)));
mappings.Add(new BulkInsertMapItem(nameof(BulkOperationIdentityTable.ColumnInt), nameof(BulkOperationIdentityTable.ColumnInt)));
mappings.Add(new BulkInsertMapItem(nameof(BulkOperationIdentityTable.ColumnNVarChar), nameof(BulkOperationIdentityTable.ColumnNVarChar)));
using (var repository = new BulkOperationIdentityTableRepository())
{
// Act
repository.InsertAll(tables);
// Act
var bulkDeleteResult = repository.BulkDelete(tables);
// Assert
Assert.AreEqual(tables.Count, bulkDeleteResult);
// Act
var countResult = repository.CountAll();
// Assert
Assert.AreEqual(0, countResult);
}
}
public void TestSystemSqlConnectionDbRepositoryBulkDeleteForTableNameEntitiesWithPrimaryKeys()
{
// Setup
var tables = Helper.CreateBulkOperationIdentityTables(10);
using (var repository = new BulkOperationIdentityTableRepository())
{
// Act
repository.InsertAll(tables);
// Setup
var primaryKeys = tables.Select(e => (object)e.Id);
// Act
var bulkDeleteResult = repository.BulkDelete(ClassMappedNameCache.Get <BulkOperationIdentityTable>(),
tables);
// Assert
Assert.AreEqual(tables.Count, bulkDeleteResult);
// Act
var countResult = repository.CountAll();
// Assert
Assert.AreEqual(0, countResult);
}
}
public void ThrowExceptionOnMicrosoftSqlConnectionBaseRepositoryBulkDeleteForEntitiesIfTheMappingsAreInvalid()
{
// Setup
var tables = Helper.CreateBulkOperationIdentityTables(10);
var mappings = new List <BulkInsertMapItem>();
// Add invalid mappings
mappings.Add(new BulkInsertMapItem(nameof(BulkOperationIdentityTable.ColumnBit), nameof(BulkOperationIdentityTable.ColumnBit)));
mappings.Add(new BulkInsertMapItem(nameof(BulkOperationIdentityTable.ColumnDateTime), nameof(BulkOperationIdentityTable.ColumnDateTime)));
mappings.Add(new BulkInsertMapItem(nameof(BulkOperationIdentityTable.ColumnDateTime2), nameof(BulkOperationIdentityTable.ColumnDateTime2)));
mappings.Add(new BulkInsertMapItem(nameof(BulkOperationIdentityTable.ColumnDecimal), nameof(BulkOperationIdentityTable.ColumnDecimal)));
mappings.Add(new BulkInsertMapItem(nameof(BulkOperationIdentityTable.ColumnFloat), nameof(BulkOperationIdentityTable.ColumnFloat)));
// Switched
mappings.Add(new BulkInsertMapItem(nameof(BulkOperationIdentityTable.ColumnInt), nameof(BulkOperationIdentityTable.ColumnNVarChar)));
mappings.Add(new BulkInsertMapItem(nameof(BulkOperationIdentityTable.ColumnNVarChar), nameof(BulkOperationIdentityTable.ColumnInt)));
using (var repository = new BulkOperationIdentityTableRepository())
{
// Act
repository.BulkDelete(tables, mappings: mappings);
}
}
public void TestSystemSqlConnectionBaseRepositoryBulkDeleteForEntities()
{
// Setup
var tables = Helper.CreateBulkOperationIdentityTables(10);
using (var repository = new BulkOperationIdentityTableRepository())
{
// Act
repository.InsertAll(tables);
// Act
var bulkDeleteResult = repository.BulkDelete(tables);
// Assert
Assert.AreEqual(tables.Count, bulkDeleteResult);
// Act
var countResult = repository.CountAll();
// Assert
Assert.AreEqual(0, countResult);
}
}
public void TestMicrosoftSqlConnectionBaseRepositoryBulkDeleteForEntitiesWithQualifiers()
{
// Setup
var tables = Helper.CreateBulkOperationIdentityTables(10);
using (var repository = new BulkOperationIdentityTableRepository())
{
// Act
repository.InsertAll(tables);
// Act
var bulkDeleteResult = repository.BulkDelete(tables,
qualifiers: Field.From("RowGuid", "ColumnInt"));
// Assert
Assert.AreEqual(tables.Count, bulkDeleteResult);
// Act
var countResult = repository.CountAll();
// Assert
Assert.AreEqual(0, countResult);
}
}
