Terry,
>I have been thinking about testing using One dataset and have each biz object add rows to their respective tables using the NewRow method. By adding a relation object I could expect ADO.Net to handle the cascading of the PK to FKs.
Sorry I didn't get back to you sooner...for some reason I didn't see this reply until today. At any rate, I think that's a good approach to take for now.
Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com