Monthly Archives: February 2012

Server-Side Paging with PetaPoco and DataTables

Posted on February 18, 2012 by Todd Wood

TL;DR – Server-side paging of table data is not only faster and more responsive, but very easy to implement with PetaPoco and DataTables. I will demonstrate how millisecond response times are still possible even when dealing with a million rows … Continue reading →

Posted in DataTables, PetaPoco | Tagged , | 10 Comments

PetaPoco DoddleReport Dynamic PIVOT Query

Posted on February 11, 2012 by Todd Wood

TL;DR – Sample ASP.NET MVC3 application demonstrating how to load PIVOT query results as a dynamic object with PetaPoco and exporting the data to Excel using DoddleReport. This blog post can be forked on GitHub: tawman / PetaPocoPivot. Dynamic Data … Continue reading →

Posted in DoddleReport, PetaPoco | Tagged , | 2 Comments

Hierarchical Data with PetaPoco Multi-Poco Mapping

Posted on February 1, 2012 by Todd Wood

TL;DR – Sample ASP.NET MVC3 application demonstrating how to load hierarchical table data with a single SQL SELECT statement using PetaPoco’s Multi-Poco mapping feature. This blog post can be forked on GitHub: tawman / PetaPocoHierarchy. PetaPoco – A Tiny ORM-ish Thing … Continue reading →

Posted in PetaPoco | Tagged | Leave a comment