Пример #1
0
        public void ShowSqlOutput()
        {
            var sqlBuilder = new SqlClient.SqlClientSqlBuilder<TestTable>();
            var pgBuilder = new PgSql.PgSqlBuilder<TestTable>();

            Console.WriteLine(sqlBuilder.ObjectName);
            Console.WriteLine(pgBuilder.ObjectName);

            Console.WriteLine("Inserts");

            Console.WriteLine(sqlBuilder.InsertString());
            Console.WriteLine(pgBuilder.InsertString());

            var table = new TestTable();

            var mutator = table.SetProperties(new { Name = "Hallo", ApeShit = "Fjert" });

            Console.WriteLine("Updates");

            Console.WriteLine(sqlBuilder.UpdateString());
            Console.WriteLine(pgBuilder.UpdateString());

            Console.WriteLine(sqlBuilder.UpdateString(mutator));
            Console.WriteLine(pgBuilder.UpdateString(mutator));

            Console.WriteLine("Deletes");

            Console.WriteLine(sqlBuilder.DeleteString());
            Console.WriteLine(pgBuilder.DeleteString());

            Console.WriteLine("Find By Id");

            Console.WriteLine(sqlBuilder.FindByIdString(table));
            Console.WriteLine(pgBuilder.FindByIdString(table));
        }