What would be the best way to to get an xml string from a sql query. I know I can use the DataSet.GetXml(), but it does not include schema...

I also found I could use:

DataSet ds = new DataSet(); 
StringWriter sr = new System.IO.StringWriter();

ds.WriteXml(sr, System.Data.XmlWriteMode.WriteSchema);
strXml = sr.ToString()

which returns the string the way I want it, but I am still going through all the overhead of a DataAdapter, DataSet, StringWriter...

Is there a better way?