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);
}
}
}
