private static void AddMockData()
        {
            var runner = new IntegrationTestsRunner();

            runner.DeleteDatabase("schoolDb");
            runner.CreateDatabase("schoolDb");
            runner.ExecuteQuery("CREATE TABLE students (Id:int,FirstName:string,LastName:string,Grade:int)", "schoolDb");
            runner.ExecuteQuery("CREATE TABLE objects (Id:int,Name:string,TeacherName:string,Language:string)", "schoolDb");
            var firstNames = new List <string>()
            {
                "Vasile", "Ion", "Gheorghe", "Nicolai", "Elena", "Stefan", "Alexandra", "Mihai", "Maria", "Ana"
            };

            var lastNames = new List <string>()
            {
                "Pojoga", "Munteanu", "Herta", "Ailenei", "Creanga", "Stan", "Budescu", "Apostol", "Mironica", "Velea"
            };

            var grades = new List <int>()
            {
                9, 4, 8, 7, 10, 9, 3, 2, 8, 10
            };

            for (var i = 0; i < 10; i++)
            {
                runner.ExecuteQuery(string.Format("INSERT INTO students(Id,FirstName,LastName,Grade) VALUES({0},'{1}','{2}',{3})", i + 1, firstNames[i], lastNames[i], grades[i]), "schoolDb");
            }

            var objectNames = new List <string>()
            {
                "Math", "Computer Science", "History", "Business", "Biology", "Chemistry", "Phisics", "Literatre", "Algorithms", "Sport"
            };

            var teacherName = new List <string>()
            {
                "Ion Neculce", "Ion Creanga", "Herta Gheorghe", "Tudorel Toader", "Dorel Lucanu", "Vlad Radulescu", "Valeriu Baltag", "Apostol Sergiu", "Mironica Maria", "Velea Alex"
            };

            var language = new List <string>()
            {
                "English", "Romanian", "Russia", "French", "English", "Romanian", "German", "Spanish", "English", "Romanian"
            };

            for (var i = 0; i < 10; i++)
            {
                runner.ExecuteQuery(string.Format("INSERT INTO objects(Id,Name,TeacherName,Language) VALUES({0},'{1}','{2}','{3}')", i + 1, objectNames[i], teacherName[i], language[i]), "schoolDb");
            }
        }
        private static void Test()
        {
            var runner = new IntegrationTestsRunner();

            var result = runner.CreateDatabase("schoolDb");

            PrintResult(result);

            result = runner.ExecuteQuery("CREATE TABLE students (Id:int,FirstName:string,LastName:string,Grade:int)", "schoolDb");
            PrintResult(result);

            result = runner.ExecuteQuery("CREATE TABLE objects (Name:string,Points:int)", "schoolDb");
            PrintResult(result);

            var firstNames = new List <string>()
            {
                "Vasile", "Ion", "Gheorghe", "Nicolai", "Elena", "Stefan", "Alexandra", "Mihai", "Maria", "Ana"
            };

            var lastNames = new List <string>()
            {
                "Pojoga", "Munteanu", "Herta", "Ailenei", "Creanga", "Stan", "Budescu", "Apostol", "Mironica", "Velea"
            };

            var grades = new List <int>()
            {
                9, 4, 8, 7, 10, 9, 3, 2, 8, 10
            };

            for (var i = 0; i < 10; i++)
            {
                result = runner.ExecuteQuery(string.Format("INSERT INTO students(Id,FirstName,LastName,Grade) VALUES({0},'{1}','{2}',{3})", i + 1, firstNames[i], lastNames[i], grades[i]), "schoolDb");
                PrintResult(result);
            }

            result = runner.ExecuteQuery("SELECT * FROM students", "schoolDb");
            PrintResult(result);

            result = runner.ExecuteQuery("SELECT * FROM students WHERE Id>0 AND Id<2 OR Grade>9 AND Id>=2 AND FirstName!='Vasile'", "schoolDb");
            PrintResult(result);

            result = runner.ExecuteQuery("DELETE FROM students WHERE Id=1 OR Id>=8", "schoolDb");
            PrintResult(result);

            result = runner.ExecuteQuery("SELECT * FROM students", "schoolDb");
            PrintResult(result);

            result = runner.ExecuteQuery("UPDATE students SET Grade=5 WHERE Grade<5", "schoolDb");
            PrintResult(result);

            result = runner.ExecuteQuery("SELECT * FROM students", "schoolDb");
            PrintResult(result);

            result = runner.ExecuteQuery("UPDATE students SET Grade=5,LastName='Failed' WHERE Grade<5 OR FirstName='Vasile'", "schoolDb");
            PrintResult(result);

            result = runner.ExecuteQuery("SELECT * FROM students", "schoolDb");
            PrintResult(result);

            result = runner.ExecuteQuery("SELECT * FROM students", "schoolDb");
            IQueryResultSerializer serializer = new CsvQueryResultSerializer();
            var csv = serializer.Serialize(result);

            System.Console.WriteLine(csv);

            result     = runner.ExecuteQuery("SELECT * FROM students", "schoolDb");
            serializer = new XmlQueryResultSerializer();
            var xml = serializer.Serialize(result);

            System.Console.WriteLine(xml);

            result = runner.ExecuteQuery("DELETE FROM students", "schoolDb");
            PrintResult(result);

            var databaseConnection = new DatabaseConnection(new DatabaseCofiguration(new DatabaseStorageService()), Constants.ServerLocation, "schoolDb");

            ITableImporter importer = new CsvTableImporter();
            var            success  = importer.Import(databaseConnection, "students", csv);

            System.Console.WriteLine(string.Format("Import from csv: {0}", success));

            importer = new XmlTableImporter();
            success  = importer.Import(databaseConnection, "students", xml);
            System.Console.WriteLine(string.Format("Import from xml: {0}", success));

            System.Console.ReadKey();
        }