Find a post...

DNN-Connect Blogs

Presentation: DNN Database Tips and Tricks

If you’re reading my blog post for the first time, you may not know that I’ve been working with DNN nearly since it was released.  That’s well over 10 years of managing DNN sites of various sizes, purposes, and deployments.  This experience has ranged from businesses that run on the platform, to running subsets of an organizations web properties on it, and more.  During my consulting days, I saw all kinds of DNN sites.  This wide range of challenges has resulted in learning a large number of things – including how to leverage SQL Server to solve problems in a creative way.  That’s what this session was about.

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 6007 7
Geoff Barlow 542 4
DNN-Connect 431 6
Peter Donker 5050 30
Christopher Hammond 678 2
Olivier Jooris 417 1
Daniel Mettler 11988 88
Clint Patterson 1 1
Jos Richters 65 1
James Rosewell 326 2
Will Strohl 1543 27
Ernst Peter Tamminga 438 4
Barry Waluszko 2756 2
Declan Ward 436 1
Gifford Watkins 722 9
Torsten Weggen 2670 3