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 543 4
DNN-Connect 431 6
Peter Donker 5052 30
Christopher Hammond 679 2
Olivier Jooris 418 1
Daniel Mettler 12001 88
Clint Patterson 1 1
Jos Richters 65 1
James Rosewell 325 2
Will Strohl 1546 27
Ernst Peter Tamminga 436 4
Barry Waluszko 2776 2
Declan Ward 439 1
Gifford Watkins 722 9
Torsten Weggen 2667 3