public List <SeasonPlayerDomainModel> ListSelectedPlayers(int SeasonID, int PositionID)
{
List <SeasonPlayerDomainModel> list = new List <SeasonPlayerDomainModel>();
//Create a Context object to Connect to the database
using (CSBAAzureEntities context = new CSBAAzureEntities())
list = (from result in context.sp_SeasonPlayerBySeason_Selected(SeasonID, PositionID)
select new SeasonPlayerDomainModel
{
SeasonID = result.SeasonID,
PlayerGUID = result.PlayerGUID,
PlayerName = result.PlayerName
}).ToList();
return(list);
}