public async Task DeleteAsync_ShouldReturnMatchingDeleteCollection_WhenDeleteTargetIsASubsetOfCollection(DbProvider provider)
{
TestEntity[] existingEntities = new[]
{
new TestEntity {
Id = "Should be delete 1", IntTestValue = -1321, BoolTestValue = false, DateTimeTestValue = DateTime.UtcNow, LongTestValue = 54123
},
new TestEntity {
Id = "Should not be delete 2", IntTestValue = 111, BoolTestValue = true, DateTimeTestValue = DateTime.UtcNow, LongTestValue = 65465132165
},
new TestEntity {
Id = "Should be delete 3", IntTestValue = -516, BoolTestValue = true, DateTimeTestValue = DateTime.UtcNow, LongTestValue = 894156156
},
};
using TestDbContext context = await ContextFactory.GetDbContextAsync(provider, existingEntities);
// Invoke the method and check that the result is the subset of entities with a negative IntTestValue
IReadOnlyCollection <TestEntity> result = await context.DeleteAsync(context.TestEntities.Where(entity => entity.IntTestValue < 0));
result.Should().BeEquivalentTo(existingEntities.Where(entity => entity.IntTestValue < 0));
// Check that the DB is empty
context.TestEntities.Should().BeEquivalentTo(existingEntities.Where(entity => entity.IntTestValue >= 0));
}
public async Task DeleteAsync_ShouldReturnEntireCollection_WhenDeleteTargetIsAllEntities(DbProvider provider)
{
TestEntity[] existingEntities = new[]
{
new TestEntity {
Id = "Should be delete 1", IntTestValue = 561645, BoolTestValue = false, DateTimeTestValue = DateTime.UtcNow, LongTestValue = 54123
},
new TestEntity {
Id = "Should be delete 2", IntTestValue = 111, BoolTestValue = true, DateTimeTestValue = DateTime.UtcNow, LongTestValue = 65465132165
},
new TestEntity {
Id = "Should be delete 3", IntTestValue = 891564, BoolTestValue = true, DateTimeTestValue = DateTime.UtcNow, LongTestValue = 894156156
},
};
using TestDbContext context = await ContextFactory.GetDbContextAsync(provider, existingEntities);
// Invoke the method and check that the result is all entities
IReadOnlyCollection <TestEntity> result = await context.DeleteAsync(context.TestEntities);
result.Should().BeEquivalentTo(existingEntities);
// Check that the DB is empty
context.TestEntities.Should().BeEmpty();
}
public async Task DeleteAsync_ShouldReturnEmptyCollection_WhenThereAreNoEntities(DbProvider provider)
{
using TestDbContext context = await ContextFactory.GetDbContextAsync(provider, seedData : null); // Note: no seed data => no entities exist
// Invoke the method and check that the result is empty
IReadOnlyCollection <TestEntity> result = await context.DeleteAsync(context.TestEntities);
result.Should().BeEmpty();
}
public async Task AsyncDeleteFromSetName()
{
using (var context = new TestDbContext(nameof(AsyncDeleteFromSetName)))
{
foreach (var item in TestHelper.DataSource)
{
await context.InsertAsync(item);
}
Assert.AreEqual(TestHelper.DataSource.Length, context.Orders.Count(), "Has data");
foreach (var item in TestHelper.DataSource)
{
await context.DeleteAsync(item);
}
Assert.AreEqual(0, context.Orders.Count(), "Has data");
}
}
public async Task DeleteAsync_ShouldReturnEmptyCollection_WhenThereAreNoMatchingEntities(DbProvider provider)
{
TestEntity[] existingEntities = new[]
{
new TestEntity {
Id = "Should not be touched 1", IntTestValue = 561645, BoolTestValue = false, DateTimeTestValue = DateTime.UtcNow, LongTestValue = 54123
},
new TestEntity {
Id = "Should not be touched 2", IntTestValue = 111, BoolTestValue = true, DateTimeTestValue = DateTime.UtcNow, LongTestValue = 65465132165
},
};
using TestDbContext context = await ContextFactory.GetDbContextAsync(provider, existingEntities);
// Invoke the method and check that the result is empty
IReadOnlyCollection <TestEntity> result = await context.DeleteAsync(context.TestEntities.Where(entity => entity.Id == "Does not exist"));
result.Should().BeEmpty();
// Check that the DB hasn't been modified
context.TestEntities.ToList().Should().BeEquivalentTo(existingEntities);
}
