public List<Associate.Location> GetLocation()
 {
     using (AssociateConnDataContext asscon = new AssociateConnDataContext())
     {
         var locations = (from a in asscon.Get_Location()
                          select new Associate.Location()
                          {
                              LocationID = a.LocationID,
                              LocationName = a.Location
                          }).ToList<Associate.Location>();
         return locations;
     }
 }