public void TestSimpleQuerySqliteInsert()
{
var conn = new SQLiteConnection($"Data Source={UnitTestExtentions.GetFileNameDb()}");
CreateTableCliente(conn);
var dateTimeBefore = DateTime.Now;
for (int i = 0; i < 1000; i++)
{
var cliente = new Cliente {
Nome = $"Cliente {i}"
};
conn.InsertReturningId(cliente);
}
var dateTimeAfter = DateTime.Now;
DropTableCliente(conn);
System.Diagnostics.Debug.WriteLine(dateTimeAfter.Subtract(dateTimeBefore).Seconds);
}
public void TestDapperSqliteInsert()
{
var conn = new SQLiteConnection($"Data Source={UnitTestExtentions. GetFileNameDb()}");
CreateTableCliente(conn);
var dateTimeBefore = DateTime.Now;
for (int i = 0; i < 1000; i++)
{
var cliente = new Cliente {
Nome = $"Cliente {i}"
};
var insertCommand = conn.GetScriptBuild().GetInsertCommand <Cliente>(cliente);
conn.Execute("insert into Cliente (Nome) values (@a)", new[] { new { a = "" } });
}
var dateTimeAfter = DateTime.Now;
System.Diagnostics.Debug.WriteLine(dateTimeAfter.Subtract(dateTimeBefore).Seconds);
DropTableCliente(conn);
}
