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;
     }
 }