public void RunTests()
{
Setup();
var stopwatch = Stopwatch.StartNew();
var sqltester = new CommandsQueriesTests(Dialect.SQLServer);
foreach (var method in typeof(CommandsQueriesTests).GetMethods(BindingFlags.Public | BindingFlags.Instance | BindingFlags.DeclaredOnly))
{
var testwatch = Stopwatch.StartNew();
Console.Write("Running " + method.Name + " in sql server");
method.Invoke(sqltester, null);
testwatch.Stop();
Console.WriteLine(" - OK! {0}ms", testwatch.ElapsedMilliseconds);
}
stopwatch.Stop();
Console.Write("\n\nSQL Server testing complete.");
// Write result
Console.WriteLine("\nTime elapsed: {0}", stopwatch.Elapsed);
using (var connection = new SqlConnection(Settings.SqlServer("master")))
{
connection.Open();
try
{
//drop any remaining connections, then drop the db.
connection.Execute(@" alter database DapperSimpleCrudTestDb set single_user with rollback immediate; DROP DATABASE DapperSimpleCrudTestDb; ");
}
catch (Exception)
{ }
}
//Console.ReadKey();
}
public void RunTests()
{
Setup();
var stopwatch = Stopwatch.StartNew();
var mysqltester = new CommandsQueriesTests(Dialect.MySQL);
foreach (var method in typeof(CommandsQueriesTests).GetMethods(BindingFlags.Public | BindingFlags.Instance | BindingFlags.DeclaredOnly))
{
//skip schema tests
if (method.Name.Contains("Schema"))
{
continue;
}
if (method.Name.Contains("Guid"))
{
continue;
}
var testwatch = Stopwatch.StartNew();
Console.Write("Running " + method.Name + " in MySQL");
method.Invoke(mysqltester, null);
Console.WriteLine(" - OK! {0}ms", testwatch.ElapsedMilliseconds);
}
stopwatch.Stop();
Console.Write("\n\nMySQL testing complete.");
Console.WriteLine("\nTime elapsed: {0}", stopwatch.Elapsed);
//Console.ReadKey();
}
public void RunTests()
{
Setup();
var stopwatch = Stopwatch.StartNew();
var pgtester = new CommandsQueriesTests(Dialect.PostgreSQL);
foreach (var method in typeof(CommandsQueriesTests).GetMethods(BindingFlags.Public | BindingFlags.Instance | BindingFlags.DeclaredOnly))
{
var testwatch = Stopwatch.StartNew();
Console.Write("Running " + method.Name + " in PostgreSQL");
method.Invoke(pgtester, null);
Console.WriteLine(" - OK! {0}ms", testwatch.ElapsedMilliseconds);
}
stopwatch.Stop();
Console.Write("PostgreSQL testing complete.");
Console.WriteLine("Time elapsed: {0}", stopwatch.Elapsed);
//Console.ReadKey();
}
