public static Game GetGame(int gameId)
{
using (var db = new GamingSystemDbContext())
{
return(db.Games.FirstOrDefaultAsync(g => g.GameId == gameId).Result);
}
}
public static void initdb()
{
using (var context = new GamingSystemDbContext())
{
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
}
}
public static Player GetPlayer(int playerId)
{
using (var db = new GamingSystemDbContext())
{
return(db.Players
.Include(p => p.PlayerGames)
.ThenInclude(pg => pg.Game)
.FirstOrDefaultAsync(p => p.PlayerId == playerId).Result);
}
}
public static void get()
{
using (var db = new GamingSystemDbContext())
{
var player = db.Players
.Include(p => p.PlayerGames)
.ThenInclude(pg => pg.Game)
.FirstOrDefaultAsync(p => p.PlayerName == "Mike").Result;
player = null;
}
}
public static void insert()
{
using (var context = new GamingSystemDbContext())
{
var game = new Game()
{
Title = "Halo", Platform = "XBox"
};
var player = new Player {
PlayerName = "Mike"
};
var playerGame = new PlayerGame {
PlayerId = player.PlayerId,
Player = player,
GameId = game.GameId,
Game = game
};
player.PlayerGames.Add(playerGame);
game.PlayerGames.Add(playerGame);
context.Players.Add(player);
context.SaveChanges();
}
}
