public List<Associate.SoftwareCategory> GetSoftwareCategory() { using (AssociateConnDataContext asscon = new AssociateConnDataContext()) { var categories = (from a in asscon.Get_SoftwareCategory() select new Associate.SoftwareCategory() { SoftwareCategoryID = a.SoftCategoryID, SoftwareCategoryDesc = a.SoftCategoryDesc }).ToList<Associate.SoftwareCategory>(); return categories; } }