public List<Associate.Designation> GetDesignation() { using (AssociateConnDataContext asscon = new AssociateConnDataContext()) { var designations = (from a in asscon.Get_Designation() select new Associate.Designation() { DesignationID = a.DesignationID, DesignationName = a.Designation }).ToList<Associate.Designation>(); return designations; } }