public TestDbFixture() { LeaguesContextFactory = new LeaguesContextFactory( "Server=(localdb)\\mssqllocaldb;Database=FliGen.Leagues.Test;Trusted_Connection=True;MultipleActiveResultSets=true"); LeaguesContext = GetInitiatedLeaguesContext(); }
private LeaguesContext CreateContextAndMigrateDb() { var leaguesContext = LeaguesContextFactory.Create(); leaguesContext.Database.Migrate(); return(leaguesContext); }
public async Task GetLeagueById(int id, TaskCompletionSource <League> receivedTask) { await using (var context = LeaguesContextFactory.Create()) { try { var entity = await context.Leagues .Include(l => l.LeagueSettings) .SingleOrDefaultAsync(l => l.Id == id); receivedTask.TrySetResult(entity); } catch (Exception e) { receivedTask.TrySetException(e); } } }
public async Task GetLeagueByName(string name, TaskCompletionSource <League> receivedTask) { await using (var context = LeaguesContextFactory.Create()) { try { var entity = await context.Leagues .SingleOrDefaultAsync(l => l.Name == name); if (entity is null) { receivedTask.TrySetCanceled(); } receivedTask.TrySetResult(entity); } catch (Exception e) { receivedTask.TrySetException(e); } } }