>>That may or may not be a good idea. The cost of constructing XML from the query results may be higher than just passing the ADO. I have not had any problems passing ADO around my n-tier applications.
>>
>
>Even across different servers? I've not benchmarked, but I always thought that was a no-no given the fact that you'd be pointing to an object on a different server.....
>
There are always tradeoffs, but I've found XML to be very slow when handling large amounts of data. Also, most databases don't natively return data as XML, so you have to do some conversion. This overhead may be slower than just passing the RS around.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer