using System; using System.Xml; using System.Data; using System.Data.SqlClient; class MainClass { public static void Main(string[] args) { XmlDocument doc = new XmlDocument(); using (SqlConnection con = new SqlConnection()) { con.ConnectionString = "server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI;"; SqlCommand com = con.CreateCommand(); com.CommandType = CommandType.Text; com.CommandText = "SELECT ID, FirstName FROM Employee FOR XML AUTO"; con.Open(); XmlReader reader = com.ExecuteXmlReader(); doc.LoadXml("<results></results>"); XmlNode newNode = doc.ReadNode(reader); while (newNode != null) { doc.DocumentElement.AppendChild(newNode); newNode = doc.ReadNode(reader); } } Console.WriteLine(doc.OuterXml); } }