I had forgotten to update this with an answer, but given @EthanTowne's comment, I dug up what I'm doing in this code now:

var o = from ords in cfg.db.OsGetUserOrders(userid)
    select ords.XML_F52E5B62_58B1_21e2_B105_00805A49AB12;
StringBuilder sb = new StringBuilder();
sb.AppendFormat("<orders>{0}</orders>", string.Join("", o.ToArray()));
XElement xe = XElement.Parse(sb.ToString());

Basically, the stored proc returns several order elements, and this code coverts them to an array then joins them into a string. Then I parse it into an XElement. There's probably a better way, and I'm open to other solutions.

Related Query

More Query from same tag