public List <v_PlayerPositionDomainModel> ListDraftPlayers()
{
//Create a return type Object
List <v_PlayerPositionDomainModel> list = new List <v_PlayerPositionDomainModel>();
using (CSBAAzureEntities context = new CSBAAzureEntities())
{
list = (from result in context.sp_PlayerPosition_Select(null)
select new v_PlayerPositionDomainModel
{
PlayerGUID = result.PlayerGUID,
PlayerImage = result.PlayerImage,
PlayerName = result.PlayerName,
PrimaryPositionID = result.PrimaryPositionID,
SecondaryPostiionID = result.SecondaryPostiionID,
PrimPosName = result.PrimPosName,
PrimPosNameLong = result.PrimPosNameLong,
SecPosName = result.SecPosName,
SecPosNameLong = result.SecPosNameLong
}).ToList();
} // Guaranteed to close the Connection
return(list);
}