public IEnumerable<Player> GetActiveByMonthAndYear(int month, int year)
{
using (var context = new BolfTrackerContext())
{
var players = (from pgs in context.PlayerGameStatistics
where pgs.Game.Date.Month == month
&& pgs.Game.Date.Year == year
select pgs.Player).Distinct();
return players.ToList();
}
}