public List <SeasonTeamDomainModel> ListRemainingTeams(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_Remaining(SeasonID) select new SeasonTeamDomainModel { TeamID = result.TeamID, TeamName = result.TeamName }).ToList(); return(list); }