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