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