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