public List <SeasonStadiumDomainModel> ListSelectedStadiums(int SeasonID)
{
List <SeasonStadiumDomainModel> list = new List <SeasonStadiumDomainModel>();
//Create a Context object to Connect to the database
using (CSBAAzureEntities context = new CSBAAzureEntities())
list = (from result in context.sp_SeasonStadiumBySeason_Selected(SeasonID)
select new SeasonStadiumDomainModel
{
StadiumID = result.StadiumID,
StadiumName = result.StadiumName
}).ToList();
return(list);
}