public int CreateUser(string name) { using (var ctx = new HighscoreContext()) { var user = new User() { Name = name }; var x = ctx.Users.Add(user); ctx.SaveChanges(); return(x.ID); } }
public int CreateGame(string name) { using (var ctx = new HighscoreContext()) { var game = new Game() { Name = name }; var x = ctx.Games.Add(game); ctx.SaveChanges(); return(x.ID); } }
public void CreateScore(int userId, int gameId, int points) { using (var ctx = new HighscoreContext()) { User user = null; foreach (var u in ctx.Users.Where(s => s.ID == userId)) { user = u; } Game game = null; foreach (var g in ctx.Games.Where(s => s.ID == gameId)) { game = g; } var score = new Score() { User = user, Game = game, Points = points }; var x = ctx.Scores.Add(score); ctx.SaveChanges(); } }