public override void MultiPocoMapping(BenchmarksContainer bc)
{
bc.Add(id =>
{
throw new NotSupportedException();
}, "SimpleData");
}
public override void QueryTop10Dynamic(BenchmarksContainer bc)
{
bc.Add(i =>
{
Enumerable.ToArray(_db.Paged(pageSize: 10).Items);
}, "Massive");
}
public override void MultiPocoMapping(BenchmarksContainer bc)
{
bc.Add(d =>
{
throw new NotSupportedException();
}, "Massive");
}
public override void Updates(BenchmarksContainer bc)
{
bc.Add(id =>
{
throw new NotSupportedException();
}, Name);
}
public override void FetchSingleDynamicEntity(BenchmarksContainer bc)
{
bc.Add(i =>
{
_db.Single(5);
}, "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 FetchSingleEntity(BenchmarksContainer bc)
{
bc.Add(d =>
{
_cnx.GetById <sfPosts>(5);
}, Name);
}
public override void FetchSingleDynamicEntity(BenchmarksContainer bc)
{
bc.Add(d =>
{
_cnx.QuerySingle <dynamic>("select * from sfPOsts where id=@id", new{ id = 5 });
}, Name);
}
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 Updates(BenchmarksContainer bc)
{
bc.Add(id =>
{
_db.Update("sfPosts", "id", new { Id = 3, Title = "updated" });
}, "PetaPoco");
}
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 FetchSingleEntity(BenchmarksContainer bc)
{
bc.Add(id =>
{
_db.Single <sfPosts>("select * from sfPosts where id=@0", 5);
}, "PetaPoco entity");
}
public override void Updates(BenchmarksContainer bc)
{
bc.Add(id =>
{
_db.sfPosts.UpdateById(new { Id = 3, Title = "updated" });
}, "SimpleData");
}
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(d =>
{
_cnx.Query <sfPosts>("select top 10 * from sfPOsts where id>@id", new { id = 5 });
}, Name);
}
public override void MultiPocoMapping(BenchmarksContainer bc)
{
bc.Add(id =>
{
_db.QuerySingle <PostViewModel>("select *,id as Author_Id,title as Author_Name from sfposts where id=@0 order by id", 5);
}, "SqlFu");
}
public override void FetchSingleDynamicEntity(BenchmarksContainer bc)
{
bc.Add(id =>
{
_cnx.Query <dynamic>("select Id,AuthorId,Title,CreatedOn,'Post' as Type,TopicId,IsActive from sfPosts where id=@id", new { id = 3 }).FirstOrDefault();
}, "Dapper query entitty dynamic");
}
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 QueryTop10Dynamic(BenchmarksContainer bc)
{
bc.Add(id =>
{
_cnx.Query <dynamic>("select top 10 Id,AuthorId,Title,CreatedOn,'Post' as Type,TopicId,IsActive from sfPosts where id>@id", new { id = 3 }).ToArray();
}, "Dapper ");
}
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 PagedQuery_Skip0_Take10(BenchmarksContainer bc)
{
bc.Add(id =>
{
throw new NotSupportedException("No implicit pagination support");
}, "Dapper ");
}
public override void FetchSingleEntity(BenchmarksContainer bc)
{
bc.Add(i =>
{
throw new NotSupportedException("not explicit type support");
}, "Massive");
}
public override void Updates(BenchmarksContainer bc)
{
bc.Add(id =>
{
_db.Update <sfPosts>(new{ Id = 3, Title = "updated" });
}, "SqlFu");
}
public override void QueryTop10(BenchmarksContainer bc)
{
bc.Add(i =>
{
throw new NotSupportedException("not explicit type support");
}, "Massive");
}
public override void FetchSingleDynamicEntity(BenchmarksContainer bc)
{
bc.Add(id =>
{
_db.QuerySingle <dynamic>("select * from sfPosts where id=@0", 5);
}, "SqlFu dynamic");
}
public override void ExecuteScalar(BenchmarksContainer bc)
{
bc.Add(i =>
{
_db.Scalar("select title from sfPosts where id=@0", 5);
}, "Massive");
}
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 Updates(BenchmarksContainer bc)
{
bc.Add(d =>
{
_db.Update(new { title = "Updated" }, 5);
}, "massive");
}
public override void PagedQuery_Skip0_Take10(BenchmarksContainer bc)
{
bc.Add(id =>
{
_db.sfPosts.FindAll(_db.sfPosts.Id > 5).Skip(0).Take(10).ToArray();
}, "SimpleData");
}
