Csharp/C Sharp/Database ADO.net/Database to XML

Use the ExecuteXmlReader() method to run a SELECT statement that returns XML

using System;
using System.Data;
using System.Data.SqlClient;
using System.Xml;
class ExecuteXmlReader
{
  public static void Main()
  {
    SqlConnection mySqlConnection =new SqlConnection("server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI;");
    SqlCommand mySqlCommand = mySqlConnection.CreateCommand();
    mySqlCommand.rumandText = "SELECT TOP 5 ID, FirstName, LastName " +
      "FROM Employee " +
      "ORDER BY ID " +
      "FOR XML AUTO";
    mySqlConnection.Open();
    XmlReader myXmlReader = mySqlCommand.ExecuteXmlReader();
    myXmlReader.Read();
    while (!myXmlReader.EOF) {
      Console.WriteLine(myXmlReader.ReadOuterXml());
    }
    myXmlReader.Close();
    mySqlConnection.Close();
  }
}

Write data in database table to XML file

using System;
using System.Data;
using System.Data.SqlClient;
   class WriteXML {
      static void Main(){
         string connString = "server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI";
         string qry = @"select * from employee";
         SqlConnection conn = new SqlConnection(connString);
         try{
            SqlDataAdapter da = new SqlDataAdapter();
            da.SelectCommand = new SqlCommand(qry, conn);
            conn.Open();
            DataSet ds = new DataSet();   
            da.Fill(ds, "employee");
            ds.WriteXml(@"employee.xml");
         } catch(Exception e) {
            Console.WriteLine("Error: " + e);
         } finally {
            conn.Close();
         }
      }
   }