Find a post...

DNN-Connect Blogs

Going MVC - getting SQL Data into Razor for DNN using SQL, PetaPoco, 2sxc

Razor is the future for most output-oriented .net stuff. This also applies to WebForms-based CMS like DNN. But fortunately, they got it right and added Razor-Support about 2 years ago. So here goes: all the ways you could use to access SQL-data directly from Razor without pre-compiling something.
So no Entity-Framework or similar. The five options we'll review are: PetaPoco, SQLReader, DataTable, 2sxc-DataPipelines

Hosting liberally provided by

Philipp Becker 6009 7
Geoff Barlow 542 4
DNN-Connect 431 6
Peter Donker 5074 30
Christopher Hammond 682 2
Olivier Jooris 418 1
Daniel Mettler 12025 88
Clint Patterson 1 1
Jos Richters 65 1
James Rosewell 327 2
Will Strohl 1547 27
Ernst Peter Tamminga 438 4
Barry Waluszko 2790 2
Declan Ward 450 1
Gifford Watkins 722 9
Torsten Weggen 2744 3