Esempio n. 1
0
        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);
        }