public IEnumerable <Member> GetMembers() { using (var context = new BasketballDataContext()) { return(context.Members.ToList()); } }
public IEnumerable <Game> GetGames() { using (var context = new BasketballDataContext()) { return(context.Games.Where(g => g.Date >= DateTime.Now).ToList()); } }
public void AddMember(Member member) { using (var context = new BasketballDataContext()) { context.Members.InsertOnSubmit(member); context.SubmitChanges(); } }
public void AddPlayer(Player player) { using (var context = new BasketballDataContext()) { context.Players.InsertOnSubmit(player); context.SubmitChanges(); } }
public void AddGame(Game game) { using (var context = new BasketballDataContext()) { context.Games.InsertOnSubmit(game); context.SubmitChanges(); } }
public List <Game> GetPlayersByGame() { using (var context = new BasketballDataContext()) { var loadOptions = new DataLoadOptions(); loadOptions.LoadWith <Game>(g => g.Players); context.LoadOptions = loadOptions; return(context.Games.Where(g => g.MaxPeople >= g.Players.Count).ToList()); } }