public void get_column_value()
{
var post = new Post()
{
Title = "title12"
};
var id = _db.Insert(post).InsertedId <int>();
Assert.Equal("title12", _db.GetColumnValue <Post, string>(p => p.Title, p => p.Id == id));
Assert.Null(_db.GetColumnValue <Post, string>(p => p.Title, p => p.Id == 2890));
}
public override void ExecuteScalar(BenchmarksContainer bc)
{
bc.Add(id =>
{
_db.GetValue <string>("select title from sfposts where id=@0", 5);
}, "SqlFu scalar");
bc.Add(id =>
{
_db.GetColumnValue <sfPosts, string>(p => p.Title, p => p.Id == 5);
}, "SqlFu get scalar expression based");
//bc.Add(id =>
//{
// _db.ExecuteScalar<int?>("select topicid from sfposts where id=@0 order by id", 5);
//}, "SqlFu scalar null to nullable");
//bc.Add(id =>
//{
// _db.ExecuteScalar<PostType>("select Type from sfposts where id=@0 order by id", 5);
//}, "SqlFu scalar enum");
}