public async Task GetAllAsync__All_tickets_found__Should_return_IEnumerable_for_all_tickets() { using (var factory = new DbContextFactory()) { using (var context = await factory.CreateContextAsync()) { int expectedLength = context.Tickets.ToArray().Length; var service = new TicketDbService(context, _logger); var result = await service.GetAllAsync(); result.Count().Should().Be(expectedLength); } } }
public async Task GetAllAsync__Resource_is_null__Should_throw_InternalDbServiceException() { using (var factory = new DbContextFactory()) { using (var context = await factory.CreateContextAsync()) { context.Tickets = null as DbSet <Ticket>; var service = new TicketDbService(context, _logger); Func <Task> action = async() => await service.GetAllAsync(); await action.Should().ThrowExactlyAsync <InternalDbServiceException>("Because resource reference is set to null"); } } }
public async Task GetAllAsync__Resource_is_empty__Should_return_empty_IEnumerable() { using (var factory = new DbContextFactory()) { using (var context = await factory.CreateContextAsync()) { context.Tickets.RemoveRange(await context.Tickets.ToArrayAsync()); await context.SaveChangesAsync(); } using (var context = await factory.CreateContextAsync()) { var service = new TicketDbService(context, _logger); var result = await service.GetAllAsync(); result.Count().Should().Be(0); } } }
public async Task GetAllAsync__Resource_doesnt_exit__Should_throw_InternalDbServiceException() { using (var factory = new DbContextFactory()) { using (var context = await factory.CreateContextAsync()) { // Drop Tickets table. context.Database.ExecuteSqlCommand("DROP TABLE [Tickets]"); } using (var context = await factory.CreateContextAsync()) { var service = new TicketDbService(context, _logger); Func <Task> action = async() => await service.GetAllAsync(); await action.Should().ThrowExactlyAsync <InternalDbServiceException>("Because resource doesnt exist and cannot get single instance of Ticket. " + "NOTE Excaption actually is type of 'SqLiteError' only if database provider is SQLite."); } } }