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 override void FetchSingleEntity(BenchmarksContainer bc)
{
bc.Add(id =>
{
_cnx.Get<sfPosts>(3);
}, "Dapper get entity");
bc.Add(id =>
{
_cnx.Query<sfPosts>("select Id,AuthorId,Title,CreatedOn,'Post' as Type,TopicId,IsActive from sfPosts where id=@id", new { id = 3 }).FirstOrDefault();
}, "Dapper query entity");
}
public override void FetchSingleDynamicEntity(BenchmarksContainer bc)
{
bc.Add(id =>
{
_db.QuerySingle<dynamic>("select * from sfPosts where id=@0", 5);
}, "SqlFu dynamic");
}
public override void MultiPocoMapping(BenchmarksContainer bc)
{
bc.Add(d=>
{
throw new NotSupportedException();
},"Massive");
}
public override void FetchSingleDynamicEntity(BenchmarksContainer bc)
{
bc.Add(d =>
{
_cnx.QuerySql("select * from sfPosts where id=@id", new { id = 5 }).FirstOrDefault();
}, Name);
}
public override void ExecuteScalar(BenchmarksContainer bc)
{
bc.Add(d =>
{
_cnx.ExecuteScalarSql<string>("select title from sfPosts where id=@id", new { id = 5 });
}, Name);
}
public override void MultiPocoMapping(BenchmarksContainer bc)
{
bc.Add(id =>
{
_db.IgnoreIfAutoMapFails.Sql("select *,id as Author_Id,title as Author_Name from sfposts where id=@0 order by id", 5).Query<PostViewModel>();
}, Name);
}
public override void FetchSingleEntity(BenchmarksContainer bc)
{
bc.Add(d=>
{
_cnx.GetById<sfPosts>(5);
},Name);
}
public override void QueryTop10Dynamic(BenchmarksContainer bc)
{
bc.Add(id =>
{
_db.Query<dynamic>("select top 10 * from sfPosts where id>@0", 5).ToArray();
}, "PetaPoco dynamic");
}
public override void MultiPocoMapping(BenchmarksContainer bc)
{
bc.Add(id =>
{
_db.Query<PostViewModel,IdName>("select p.*,p.Id ,p.title as Name from sfposts p where p.id=@0 order by p.id", 5).FirstOrDefault();
}, "PetaPoco");
}
public override void FetchSingleEntity(BenchmarksContainer bc)
{
bc.Add(id=>
{
_db.Single<sfPosts>("select * from sfPosts where id=@0", 5);
},"PetaPoco entity");
}
public override void MultiPocoMapping(BenchmarksContainer bc)
{
bc.Add(id =>
{
_db.FirstOrDefault<PostViewModel>("select *,id as Author_Id,title as Author_Name from sfposts where id=@0 order by id",5);
}, "SqlFu");
}
public override void QueryTop10(BenchmarksContainer bc)
{
bc.Add(d =>
{
_cnx.Query<sfPosts>("select top 10 * from sfPosts where id>@id", new { id = 5 }, commandType: CommandType.Text).ToArray();
}, Name);
}
public override void FetchSingleEntity(BenchmarksContainer bc)
{
bc.Add(d=>
{
_cnx.Query<sfPosts>("select * from sfPosts where id=@id", new {id = 5},commandType:CommandType.Text).FirstOrDefault();
},Name);
}
public override void FetchSingleDynamicEntity(BenchmarksContainer bc)
{
bc.Add(i =>
{
_db.Single(5);
}, "Massive");
}
public override void PagedQuery_Skip0_Take10(BenchmarksContainer bc)
{
bc.Add(id =>
{
_db.PagedQuery<sfPosts>(0,10,"select * from sfposts where id>@0", 5);
}, "SqlFu");
}
public override void QueryTop10(BenchmarksContainer bc)
{
bc.Add(i =>
{
throw new NotSupportedException("not explicit type support");
}, "Massive");
}
public override void QueryTop10(BenchmarksContainer bc)
{
bc.Add(d =>
{
_cnx.Query<sfPosts>("select top 10 * from sfPOsts where id>@id", new { id = 5 });
}, Name);
}
public override void QueryTop10Dynamic(BenchmarksContainer bc)
{
bc.Add(i =>
{
Enumerable.ToArray(_db.Paged(pageSize: 10).Items);
}, "Massive");
}
public override void QueryTop10Dynamic(BenchmarksContainer bc)
{
bc.Add(d =>
{
_cnx.QuerySql("select top 10 * from sfPosts where id>@id", new { id = 5 }).ToArray();
}, Name);
}
public override void ExecuteScalar(BenchmarksContainer bc)
{
bc.Add(i=>
{
_db.Scalar("select title from sfPosts where id=@0", 5);
},"Massive");
}
public override void MultiPocoMapping(BenchmarksContainer bc)
{
bc.Add(d =>
{
_cnx.QuerySql<PostViewModel, IdName>("select *, Id, title as Name from sfposts p where id=@id order by p.id", new { id = 5 });
}, Name);
}
public override void QueryTop10Dynamic(BenchmarksContainer bc)
{
bc.Add(id =>
{
_db.Query<dynamic>("select top 10 * from sfposts where id>@0", 5);
}, "SqlFu");
}
public override void MultiPocoMapping(BenchmarksContainer bc)
{
bc.Add(id =>
{
throw new NotSupportedException();
}, "SimpleData");
}
public override void ExecuteScalar(BenchmarksContainer bc)
{
bc.Add(d =>
{
_cnx.ExecuteScalar<int>("select authorid from sfPosts where id=@id", new { id = 5 }, commandType: CommandType.Text);
}, Name);
}
public override void PagedQuery_Skip0_Take10(BenchmarksContainer bc)
{
bc.Add(id =>
{
_db.sfPosts.FindAll(_db.sfPosts.Id > 5).Skip(0).Take(10).ToArray();
}, "SimpleData");
}
public override void QueryTop10Dynamic(BenchmarksContainer bc)
{
bc.Add(id =>
{
_db.sfPosts.FindAll(_db.sfPosts.Id>5).ToArray();
}, "SimpleData");
}
public override void QueryTop10(BenchmarksContainer bc)
{
bc.Add(id=>
{
throw new NotSupportedException();
}, "SimpleData");
}
public override void FetchSingleDynamicEntity(BenchmarksContainer bc)
{
bc.Add(id =>
{
_db.sfPosts.Get(5);
}, "SimpleData dynamic");
}
public override void FetchSingleEntity(BenchmarksContainer bc)
{
bc.Add(id=>
{
throw new NotSupportedException();
},"SimpleData");
}
