public List <v_PlayerPositionDomainModel> ListPlayerPositionSeason(int SeasonID, int PositionID, bool bDrafted)
{
//Create a return type Object
List <v_PlayerPositionDomainModel> list = new List <v_PlayerPositionDomainModel>();
using (CSBAAzureEntities context = new CSBAAzureEntities())
{
list = (from result in context.DraftPlayersStatus(SeasonID, PositionID, bDrafted)
select new v_PlayerPositionDomainModel
{
PlayerGUID = result.PlayerGUID,
PlayerImage = result.PlayerImage,
PlayerName = result.PlayerName,
PrimaryPositionID = result.PrimaryPositionID,
}).ToList();
} // Guaranteed to close the Connection
return(list);
}