public List <DraftPlayerDomainModel> DraftPositionStatus(int SeasonID, int iDrafted)
{
List <DraftPlayerDomainModel> listPos = new List <DraftPlayerDomainModel>();
using (CSBAAzureEntities context = new CSBAAzureEntities())
{
listPos = (from result in context.DraftPositionStatus(SeasonID) where result.Drafted == iDrafted
select new DraftPlayerDomainModel
{
Drafted = result.Drafted,
PosCount = (int)result.PosCount,
PositionName = result.PositionName,
SeasonID = result.SeasonID
}).ToList();
} // Guaranteed to close the Connection
return(listPos);
}