3 people following this project (follow)

Project Description

Generation tool for random queries in SQL in the Windows environment. Can produce random queries, tables, deletes, and updates as well as generate random data for a table. Structured to allow easy adaptation for other SQL implementations as well.
Quickly run random queries on your database for testing with almost no effort.

Insert 100 random records
PgSqlGenerator pg = new PgSqlGenerator("127.0.0.1", 5432, "postgres", "sql", "my_database");
Table people = pg.GetTable("people");
QueryInformation report = pg.ExecuteBulkInsert(people, 100);

//now check the results:
Console.WriteLine("Query: " + report.Query);
Console.WriteLine("Time Taken: " + report.Time);
Console.WriteLine("Records Affected: " + report.Affected);

Requirements

  • .Net 4.0
  • One of the following Databases:
    • PostgreSQL 7.0+

Last edited Dec 3 2010 at 5:21 PM by naspinski, version 7