Exemplos de CSBAAzureEntities.sp_SeasonPlayerBySeason_Selected em C# (CSharp)

Exemplo n.º 1

Arquivo: SeasonPlayerDAL.cs Projeto: tstbag/CSBAWebFall2019

        public List <SeasonPlayerDomainModel> ListSelectedPlayers(int SeasonID, int PositionID)
        {
            List <SeasonPlayerDomainModel> list = new List <SeasonPlayerDomainModel>();

            //Create a Context object to Connect to the database
            using (CSBAAzureEntities context = new CSBAAzureEntities())

                list = (from result in context.sp_SeasonPlayerBySeason_Selected(SeasonID, PositionID)
                        select new SeasonPlayerDomainModel
                {
                    SeasonID = result.SeasonID,
                    PlayerGUID = result.PlayerGUID,
                    PlayerName = result.PlayerName
                }).ToList();

            return(list);
        }