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