public static CatMatchMariaDbContext GetDbContext() { var options = new DbContextOptionsBuilder <CatMatchMariaDbContext>(); options.UseMySql("Server=localhost;Database=catmatch;User=root;Password=root;", (actions) => { actions.ServerVersion(new Version(10, 3, 14), ServerType.MariaDb); }); var context = new CatMatchMariaDbContext(options.Options); context.Database.EnsureCreated(); return(context); }
private async Task <(int EloLeft, int EloRight)> LoadElo(int leftId, int rightId, CatMatchMariaDbContext context) { var left = await context.Cats.IncludeSubModels().AsNoTracking() .Select(e => new { Id = e.Id, Elo = e.Rank.Elo }) .FirstOrDefaultAsync(c => c.Id == leftId) .ConfigureAwait(false); var right = await context.Cats.IncludeSubModels().AsNoTracking() .Select(e => new { Id = e.Id, Elo = e.Rank.Elo }) .FirstOrDefaultAsync(c => c.Id == rightId) .ConfigureAwait(false); return(left.Elo, right.Elo); }