public DraftStatusDomainModel DraftStatus(int SeasonID) { DraftStatusDomainModel dStatus = new DraftStatusDomainModel(); using (CSBAAzureEntities context = new CSBAAzureEntities()) { dStatus = (from result in context.DraftPlayerStatus(SeasonID) select new DraftStatusDomainModel { SeaonPlayerTotal = result.SeaonPlayerTotal, SeasonPlayerDrafted = result.SeasonPlayerDrafted }).FirstOrDefault(); } // Guaranteed to close the Connection return(dStatus); }