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 6015 7
Geoff Barlow 548 4
DNN-Connect 431 6
Peter Donker 5066 30
Christopher Hammond 681 2
Olivier Jooris 419 1
Daniel Mettler 12019 88
Clint Patterson 1 1
Jos Richters 65 1
James Rosewell 327 2
Will Strohl 1546 27
Ernst Peter Tamminga 438 4
Barry Waluszko 2814 2
Declan Ward 474 1
Gifford Watkins 723 9
Torsten Weggen 2715 3