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.

Amit Patel
Amit Patel

I am  C# Corner MVP in Q2 2012.  I have 10 years of experiences in Microsoft technologies. I am very much passionate about Web technology. My core skill is ASP.NET, WCF, C#, JQuery and CSS.



Custom Software Development
MCN is your source for developing solutions involving websites, mobile apps, cloud-computing, databases, BI, back-end services and processes and client-server applications.

Trending up