public IList<Position> GetPositions(List<string> positionNames) { using (var context = new BaseballContext()) { var positions = context.Positions.Where(p => positionNames.Contains(p.Alias)).ToList(); return positions; } }
public IEnumerable<Player> GetPlayers() { using (var context = new BaseballContext()) { var players = context.Players.Include(player => player.Person.PersonType).Include(p => p.Positions).ToList(); return players; } }
public Player GetPlayer(string firstName, string lastName) { using (var context = new BaseballContext()) { var player = context.Players .Include(p => p.Person.PersonType) .FirstOrDefault(p => p.Person.FirstName.ToLower() == firstName.ToLower() && p.Person.LastName.ToLower() == lastName.ToLower()); return player; } }
public void AddPlayer(Player player) { using (var context = new BaseballContext()) { foreach (var position in player.Positions) { context.Positions.Attach(position); } context.Players.Add(player); context.SaveChanges(); } }