public List<Associate.Category> GetCategories()
 {
     using (AssociateConnDataContext asscon = new AssociateConnDataContext())
     {
         var groups = (from a in asscon.Get_Category()
                       select new Associate.Category()
                       {
                           CategoryID = a.CategoryID,
                           CategoryDesc = a.CategoryDesc
                       }).ToList<Associate.Category>();
         return groups;
     }
 }