I think I misspoke my intentions a bit.

I'm converting the VFP app into a 3 tier app first, then
later to .Net.

First the app will be converted to look at the VFP DB through
BO's and a data class, returning data as XML. These VFP components
will be built as COM objects.

Then, after this is done, I will convert the data to SQL. Then after
that, I will convert the app to .Net.

So, can I use a CA to call a stored proc in the VFP DB and get the results
back as XML? Can you point me to an example?

And, I'm still not sure where the right place for each piece is. It seems
that if I place the code to convert the data to XML in the stored proc, then
any process calling the SP gets the data back as XML. THis seems like it should
be in the BO.

I would appreciate your comments on this design schema.

Thans





>a) You can use the VFP 9.0 OLE DB Provider to have it return XML.
>
>b) If the BOs and data objects are in .NET, you don't want them to be COM.
>
>>I am converting an app from VFP to .Net
>>
>>I want to create some Stored Procedures in the VFP database
>>that mimic those that I will create in the SQL DB so that
>>I can test my business objects.
>>
>>I would like the app to receive its data as XML, so either
>>the stored procedure or the BO must ensure that the data
>>returned is in this format.
>>
>>2 Questions:
>>
>>A) Where is the best place to ensure the data is in XML? I would
>>think the BO, that way any process can request data from the DB and
>>get it back in native format.
>>
>>B) If the BO calls a stored proc in the DB, what format would the data be in
>>when it's returned to the BO? I would like to compile the BO's and data access
>>objects into COM components.
>>
>>Thanks