public List <sp_SeasonTeamDraft_Select_ResultDomainModel> DraftTeamList(int SeasonID)
{
List <sp_SeasonTeamDraft_Select_ResultDomainModel> listTeams = new List <sp_SeasonTeamDraft_Select_ResultDomainModel>();
using (CSBAAzureEntities context = new CSBAAzureEntities())
{
listTeams = (from result in context.sp_SeasonTeamDraft_Select(SeasonID)
select new sp_SeasonTeamDraft_Select_ResultDomainModel
{
CountHitter = result.CountHitter,
CountPlayers = result.CountPlayers,
MaxBid = result.MaxBid,
MinBid = result.MinBid,
OwnerEmail = result.OwnerEmail,
OwnerName = result.OwnerName,
OwnerUserID = result.OwnerUserID,
PitcherCount = result.PitcherCount,
SeasonID = result.SeasonID,
StartPoints = result.StartPoints,
SumPoints = result.SumPoints,
TeamID = result.TeamID,
TeamName = result.TeamName
}).ToList();
} // Guaranteed to close the Connection
return(listTeams);
}
