public Associate.Associate GetAssociateByID(string AssociateID) { int id = (AssociateID == string.Empty) ? 0 : Convert.ToInt32(AssociateID); using (AssociateConnDataContext asscon = new AssociateConnDataContext()) { var associates = (from a in asscon.Get_AssociateByID(id) select new Associate.Associate() { AssociateID = a.AssociateID, FirstName = a.FirstName, LastName = a.LastName, Designation = a.Designation, Practice = a.PracticeName, Account = a.AccountName, Location = a.Location, email = a.email, Mobile = a.Mobile, DOJ = a.DOJ, ProjectName = a.ProjectName, Gender = a.Gender }).SingleOrDefault<Associate.Associate>(); return associates; } }