When should I use the CommandStream vs. the CommandText property?
The CommandText property should be used when you are just passing in some text. The benefit is that you do not have to load the text into a stream to pass it.
http://www.sqlxml.org/faqs.aspx?faq=35