/// <summary> /// Using the provided database information, this method dumps the current table to an xml file. /// </summary> /// <param name="dc">the database we use</param> /// <param name="filename">the name of the file with no extension</param> private static void DumpTableToXML(DatabaseController dc, string filename) { DataTable dataTable; using (MySqlDataReader reader = dc.GetReader()) { dataTable = reader.GetSchemaTable(); dataTable.Load(reader); } XmlTextWriter xmlTWriter = new XmlTextWriter(Directory.GetCurrentDirectory() + "\\" + filename + ".xml", Encoding.Default); xmlTWriter.Formatting = Formatting.Indented; try { dataTable.WriteXml(xmlTWriter, true); } catch (Exception e) { Console.WriteLine("Error: " + e.Message); } }
static void Main(string[] args) { DatabaseController dc = new DatabaseController(); if (!dc.TryConnectToDatabase()) { return; } if (args.Length > 0) { dc.SetTable(args[0]); } else { dc.SetTable("ITEM"); } DumpTableToXML(dc, "output"); if (!dc.TryCloseConnection()) { return; } }