public List <SeasonTeamDomainModel> ListSelectedTeams(int SeasonID)
{
List <SeasonTeamDomainModel> list = new List <SeasonTeamDomainModel>();
//Create a Context object to Connect to the database
using (CSBAAzureEntities context = new CSBAAzureEntities())
list = (from result in context.sp_SeasonTeamBySeason_Selected(SeasonID)
orderby result.TeamName
select new SeasonTeamDomainModel
{
ActiveFlg = result.ActiveFlg,
SeasonID = result.SeasonID,
StadiumOrder = result.StadiumOrder,
TeamID = result.TeamID,
TeamName = result.TeamName
}).ToList();
return(list);
}