public override void FetchSingleEntity(BenchmarksContainer bc)
{
bc.Add(id =>
{
_db.Get <sfPosts>(5);
}, "SqlFu Get");
bc.Add(id =>
{
_db.QuerySingle <sfPosts>("select * from sfPosts where id=@0", 5);
}, "SqlFu FirstOrDefault");
}
public void create_if_exists_ignore()
{
Table.ExecuteDDL();
Db.Insert(TableName, new { Name = "aha", Uid = Guid.NewGuid() });
var ddl = Db.DatabaseTools.GetCreateTableBuilder(TableName, IfTableExists.Ignore);
ddl.Columns.Add("sid", DbType.Int32);
Assert.DoesNotThrow(() => ddl.ExecuteDDL());
var cnt = Db.QuerySingle <dynamic>("select * from " + Db.Provider.EscapeName(TableName));
Assert.Equal("aha", cnt.Name);
}