Monthly Archives: February 2012

Server-Side Paging with PetaPoco and DataTables

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 , | 11 Comments

PetaPoco DoddleReport Dynamic PIVOT Query

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

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 | 1 Comment