Posts Tagged ‘Linq to Sql’

Using the Linq to Sql Adapter in a DotNetNuke Module

Tuesday, October 14th, 2008

In a previous entry, I discussed a potential solution to a longstanding problem.  The DotNetNuke CMS framework allows declaration of an object qualifier and database owner on a per-installation basis.  This effectively varies the fully-qualified database entity names at runtime.  Because the Linq to Sql system by default utilizes a class attribution approach, it does not lend itself well to such runtime adaptation.

Here I describe the steps necessary to use Linq to Sql within a DotNetNuke module in a reliable, distributable manner.

(more…)

Tags:, ,
Posted in DotNetNuke (DNN) Content Management System, Technology | 5 Comments »

Adapting the Linq to Sql Attributed Meta-Model for Use in DotNetNuke

Tuesday, October 14th, 2008

The .NET-supplied DataContext allows Linq to Sql development using the attributed model automatically generated by a Visual Studio designer. However, when deployed within DotNetNuke, these attributes do not pick up the database owner and object qualfier required by DotNetNuke.  Because of this, large-scale deployment of modules using Linq to Sql is infesable, and modules using the technology are unfortunately limited to internal applications.

To rememdy this issue, I have developed an adapter that converts the attributed meta model generated by the designer into a DotNetNuke-compatable model that uses both the object qualifier and database owner specified by an end-installation. 

(more…)

Tags:, , ,
Posted in DotNetNuke (DNN) Content Management System, Technology | 1 Comment »