DataSet To Xml (Convert Multiple Tables to XML file)

DsToXML.cs

            string connectionString = "Server=192.168.2.56;Database=NEWDB;User Id=SA;Password=123456;";
            var conn = new SqlConnection(connectionString);
            conn.Open();
            var tables = new[] { "Categories", "CustomerCustomerDemo", "Employees", "Territories" };
            var sb = new StringBuilder();

            foreach (var table in tables)
            {
                var ds = new DataSet();
                var query = "SELECT * FROM " + table + " ";
                var cmd = new SqlCommand(query, conn);
                var da = new SqlDataAdapter(cmd);
                da.Fill(ds, table);
                sb.AppendLine(ds.GetXml());
            }

            File.WriteAllText(@"c:\\temp\arquivo.xml", "<root>"+  sb.ToString() + "</root>");
            conn.Close();
            conn.Dispose();