>Ok, so the Data Object contains the SQL code.
>
>If I have a Customer BO, I might have a GetCustomerByID procedure.
>The BO would pass the Id to the Data object, which would run a
>query for that Id? Sound right?
Yup, that sounds right
>
>Now, say I wanted to call stored procs in the DO instead, how would I set up
>the stored procedure? If I had the following procedure:
>
>
>procedure GetCustomerById(nId as integer)
>select * from customers where Id = nId
>
>
>How would I return the results to the BO? Would you have the DO convert the
>results to XML, or do that in the BO?
>
Since the SP won't return a cursor, the SP will have to do the conversion to XML. The DO should not be generic; it should be custom for each backend to take advantage of the database's strengths.
>Thanks
>
>
>
>
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer