Dynamic Data with DotNetNuke

(This is being tracked in this thread: http://forums.asp.net/p/1199644/2084682.aspx#2084682 )

also see: Non DNN Dynamic Data Test

1) Install ASP.NET 3.5 extension preview 

2) Install DotNetNuke 4.8 or higher

3) Use this web.config because it has all the keys you will need (right now this only works if you use the development web server that is included with Visual Studio. The web.config is configured to use SQL Server Express but you can change the connection string to use SQL Server).

4) Create a App_Shared directory in the root of the DotNetNuke website and add these files: DynamicDataFields.zip

5) Install the Dynamic Module into the DotNetNuke site: DynamicWebsite_01.00.00_Install.zip

6) Place the module on a page in your DotNetNuke site.

Module allows you to navigate the tables as well as insert, update, and delete data

 

Create a new module by only changing the database

1) Import the Northwind sample database into the DotNetNuke site:

2) Open the DataClasses.dbml file:

3) Highlight the existing classes and use the Delete button to delete them.

4) Switch to the Database Explorer and locate the Northwind data connection. Highlight some of the tables in the Northwind database:

5) Drag and drop them on the Object Relational Designer

6) Save the DataClasses.dbml file and refresh the web page:

The module will now allow you to administer the tables:

 

Important Notes

At this stage this is just a preview of what will be implemented when Dynamic Data is finally released. This sample code is brittle and prone to break so no attempt should be made to use it in production. This code was created to provide feedback to the Dynamic Data team as they develop the product.

Using Dynamic Data outside of DotNetNuke is however stable but is still in CTP (Community Technology Preview) stage and subject to change.

History

1-6-2008 - First DotNetNuke module posted

 

Known Issues

If you add a Product (for example Product3) and then try to view orders:

You get an error because there are no orders

However you wont be able to add an order because the product wont show up:

* Also using the Employees table from the Northwind Database when imported in this manner throws an error that Employees cannot be the same name as the containing class.

[Back to: The ADefWebserver DotNetNuke HELP WebSite]

DotNetNukeŽ is a registered trademark of the DotNetNuke Corporation