private static List <Contact> GetCustomerData() { using (var db = new SqlConnection(ConnectionHelper.ConnectionString)) { db.Open(); var sp = new Sproc("Person.spGetSomeContacts", db); List <Contact> results; sp.Execute(out results); foreach (var contact in results) { var exsp = new Sproc("Person.spGetExtendedData", db); exsp.SetParam("@ContactId", contact.ContactId); List <ExtensibleDataItem> dataFields; exsp.Execute(out dataFields); CollectionHelper.UpdateObjectFromExtensibleData(dataFields, contact); contact.AcceptChanges(); } return(results); } }