>>Were you using stored procedures to do updates, deletes and inserts as well?
Yep, stored procedures for all updates, deletes, inserts, selects and anything else you want to benefit from the performance boost.

>>We've had quite a bit of discussion here over the best way to do things. >>Current literature claims that doing everything through stored procedures is >>faster.
And believe it or not, easier once you get comfortable with TSQL and the data driven approach to developing data access classes.

Charlie