static void Main(string[] args) { FactoryConnection factoryConnection = new FactoryConnection(); System.Diagnostics.Stopwatch sw = System.Diagnostics.Stopwatch.StartNew(); XMLConnection xmlConnection = factoryConnection.openXMLConnection("../../Database.xml"); DataObject xmlObj = xmlConnection.loadDataObject(); xmlObj.DataSet.Tables[2].Rows[0]["pattern_binary_level"] = 1127; xmlConnection.saveDataObject(xmlObj); sw.Stop(); Console.WriteLine("-------------------------------"); Console.WriteLine("-------- XML ------------"); Console.WriteLine("-------------------------------"); for (int i = 0; i < xmlObj.DataSet.Tables.Count; i++) { Console.WriteLine(xmlObj.DataSet.Tables[i].TableName); foreach (DataRow row in xmlObj.DataSet.Tables[i].Rows) { foreach (DataColumn col in xmlObj.DataSet.Tables[i].Columns) { Console.WriteLine(col.ColumnName + " : " + row[col.ColumnName]); } } Console.WriteLine("-------------------------------"); } System.Diagnostics.Stopwatch sw2 = System.Diagnostics.Stopwatch.StartNew(); SqliteConnection sqliteConnection = factoryConnection.openSqliteConnection("../../test.db"); DataObject sqliteObj = sqliteConnection.loadDataObject(); sqliteObj.DataSet.Tables[0].Rows[0]["seq"] = 111; sqliteConnection.saveDataObject(sqliteObj); sw2.Stop(); Console.WriteLine(""); Console.WriteLine("-------------------------------"); Console.WriteLine("------- SQLite -----------"); Console.WriteLine("-------------------------------"); for (int i = 0; i < sqliteObj.DataSet.Tables.Count; i++) { Console.WriteLine(sqliteObj.DataSet.Tables[i].TableName); foreach (DataRow row in sqliteObj.DataSet.Tables[i].Rows) { foreach (DataColumn col in sqliteObj.DataSet.Tables[i].Columns) { Console.WriteLine(col.ColumnName + " : " + row[col.ColumnName]); } } Console.WriteLine("-------------------------------"); } Console.WriteLine("Time XML: {0} ms", sw.ElapsedMilliseconds); Console.WriteLine("Time SQLite: {0} ms", sw2.ElapsedMilliseconds); Console.ReadKey(); }
public XMLConnection openXMLConnection(string sourceFile) { XMLConnection xmlConnection = new XMLConnection(sourceFile); return(xmlConnection); }