Beispiel #1
0
        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);
        }