public Address GetAddress(string accountno) { Address address = null; using (GoldmineEntities context = new GoldmineEntities()) { CONTACT1 contact1Record = (from c in context.CONTACT1.Where(x => x.ACCOUNTNO == accountno) select c).FirstOrDefault(); if (contact1Record != null) { address = AddressHelper.ConvertToAddress(contact1Record); } } return(address); }