SQL to XML

gistfile1.cs

XElement root = new XElement("Orders");
using (SqlConnection con = new SqlConnection("data source=LMATT-PC\\SQLEXPRESS;integrated security=SSPI"))
{
    con.Open();
	using(SqlCommand command = new SqlCommand("SELECT top 50 * from Spt_values", con))
	{
	SqlDataReader reader = command.ExecuteReader();
	while(reader.Read())
	{
		root.AddFirst(
		    new XElement("Order", 
			from i in Enumerable.Range(0, reader.FieldCount)
			select
				new XElement(reader.GetName(i), reader.GetValue(i))
			)
		);
	 }
	 root.Save(Console.Out);
	 }
}