Scroll To Top
Reader Level:

Creating a Dynamic Data Web Site in ASP.NET 4.0

By Amit Patel on Jul 05, 2012
You can create Dynamic Data Web sites in Visual Studio by using ASP.NET Dynamic Data templates.

Steps to create a new ASP.NET Dynamic Application with Linq to SQL.

Step 1: To create a new web application and application type will be using an ASP.Net Dynamic Data Linq to SQL Web Application.

Step 2: Now we'll add a database toe the web application. I have added a MDF file in the App_data folder.

Step 3: Now we'll add LINQ to SQL Classes.

Step 5: Now we will add the requied tables in the DBML file.

Step 6: Now when you run your application you will get the following error:

To resolve the error we need to make some changes in the Global.asax file.

By default this line is commented:

DefaultModel.RegisterContext(typeof(YourDataContextType), new ContextConfiguration() { ScaffoldAllTables = false });

we need to add our entity context there and ScaffoldAllTables should be true.

DefaultModel.RegisterContext(typeof(DataClassesDataContext), new ContextConfiguration() { ScaffoldAllTables = true});

Step 7: Now when we run our application the output will be:
You will see three tables in the above image. The Customer and Store tables can accept null value for their colums. But the Employee Table will not accept a null value because we have add a null contraint to all columns.

The conclusion is that we can easily create Data Dynamic applications.