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.
    • Like
    • Love It
    • Awesome
    • Interesting
    • It's Okay
    • Thumbs Down
  • 31.7k
  • 0

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.