What are your reasons for doing it in a single operation?

Scalable performance/speed, as well as elegance.

I may take a look at the stored procedures you recommended.
I was trying to avoid having to use actual SQL in my code, as it appears kludgy to me. Stored procedures appears to be a happy medium.