public List <SeasonPlayerDomainModel> ListRemainingPlayers(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_Remaining(SeasonID, PositionID) select new SeasonPlayerDomainModel { SeasonID = SeasonID, PlayerGUID = result.PlayerGUID, PlayerName = result.PlayerName }).ToList(); return(list); }