If you need to connect to multiple backends, the business objects should talk to a Data Facade object. It will then pass the data to a data layer component. You should have one data layer compenent for each data source (VFP, SQL, Oracle, etc).
>I've using XML to transport Visual FoxPro data between tiers in a COM+ DLL, it's pretty straigfull when you are using it to read the data.
>
>The new problem I've found is about how to send the update from the business tier to the data tier, with Visual FoxPro I can produce an XML Diffgram (trough XMLUpdategram() function or CursorAdapter class), but I'm finding problems to send this kind of XML when I prettend to not use MS SQLServer.
>
>It will be cool if I could create a .NET Adapter (SQLAdapter, OLEDBAdapter, etc) we could update any kind of datasource, obviously the mayor work will be in How to move between the Diffgram elements (the before/after elements).
>
>My question is: How can I move between Items in a XMLDiffgram?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer