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

Geoff Barlow 558 4
DNN-Connect 432 6
Peter Donker 5241 31
Christopher Hammond 701 2
Olivier Jooris 424 1
Daniel Mettler 12096 88
Clint Patterson 1 1
Jos Richters 65 1
James Rosewell 336 2
Will Strohl 1552 27
Ernst Peter Tamminga 443 4
Barry Waluszko 2952 2
Declan Ward 530 1
Gifford Watkins 725 9
Torsten Weggen 2879 3