using System;

using System.Xml.Linq;

​

public class Program

{

    public static void Main(string[] args)

    {

        XDocument xDocument = XDocument.Parse(

@"

<root>

<data name=""GetOrdersMailMsg"" xml:space=""preserve"">

<value>

        SELECT Orders.buyersEmail,

            Orders.emailMessage

            FROM Orders

            WHERE Orders.orderId = '{0}'

    </value>

<comment>Get email message(s) to buyer</comment>

</data>

<data name=""UpdateOrdersMailMsg"" xml:space=""preserve"">

<value>

        UPDATE Orders

            SET    Orders.buyersEmail = '{0}',

                    Orders.emailMessage = '{1}'

            WHERE Orders.orderId = '{2}'

    </value>

<comment>Update mail message to buyer</comment>

</data>

</root>

");

        foreach (XElement xElement in xDocument.Root.Elements("data"))

        {

            Console.WriteLine("name:" + xElement.Attribute("name").Value.ToString());

            Console.WriteLine("value:" + xElement.Element("value").Value.ToString());

        }

    }

}