public List <SeasonStadiumDomainModel> ListRemainingStadiums(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_Remaining(SeasonID) select new SeasonStadiumDomainModel { StadiumID = result.StadiumID, StadiumName = result.StadiumName }).ToList(); return(list); }