Example #1
0
        static void TestSQLite()
        {
            var            table = CreateTestTable();
            SQLiteDatabase db    = new SQLiteDatabase("MYDB");

            db.CreateTable("MYTABLE", table);
            var table2 = db.InspectDatabase();
            var table3 = db.GetDataTable("MYTABLE");

            var obj    = CreateTestArray();
            var table4 = ExcelFriendlyConversion.ConvertObjectArrayToDataTable("MYTABLE4", obj);

            PrintTableInfoToConsole(table4);

            db.CreateTable("MYTABLE4", table4);
            var table5 = db.GetDataTable("MYTABLE4");

            PrintTableInfoToConsole(table5);


            Console.WriteLine("Database created ..");
        }