In this article, I will explain how to work with a Dynamic Data Entities Web Application which is available when a project is created.
In this article, I will show how to implement a CRUD operation without writing a single line of code and by just un-commenting a line in the Global.asax file.
The only thing you have to do is to add a reference in the Global.asax file with your project name you created. Since my project name is dynamicdataentities I will add this as a reference as follows:
  1. using dynamicdataentities;
The only thing you have to do after this is to un-comment this line of code from the Global.asax file:
  1. DefaultModel.RegisterContext(typeof(YourDataContextType), new ContextConfiguration() { ScaffoldAllTables = false });
You have to replace this with the following:
  1. DefaultModel.RegisterContext(typeof(codeDBEntities), new ContextConfiguration() { ScaffoldAllTables = true });
Here codeDBEntities is nothing but the connection string which is available in the Web.config file or you can find it in Model.edmx.
First, let us create a project by selecting ASP.NET Dynamic Data Entities Web Application as follows:
Figure 1.jpg
This will create a project with a Master page, a Default page, and a Global.asax file along with script and CSS.
Now let us add an ADO.NET Entity Data Model as we did in our last article; see:
Figure 2.jpg
Figure 3.jpg
Since I already have a connection I am not showing how to add a connection; I will proceed with what I have.
Figure 4.jpg
Figure 5.jpg
Open the Global.asax file from the Solution Explorer:
Figure 6.jpg
You can find some code with comments, we will un-comment the one we need as follows:
Figure 7.jpg
Here in the place of YourDataContextType, you have to replace your context type which will be available in the web.config or Model.edmx:
Figure 8.jpg
Figure 9.jpg
Figure 10.jpg
Now run your application.
Figure 11.jpg
Since I integrated 2 tables it is showing those tables, select what is required to perform the CRUD operations.
I selected Employee and the details are as follows:
Figure 12.jpg
In the department dropdown you can determine the entire department listed, as follows:
Figure 13.jpg
If I select any then the corresponding details are shown as follows:
Figure 14.jpg
Inserting details into Employee table, if you select Insert New Item then it will display as follows:
Figure 15.jpg
Edit Update screen
Figure 16.jpg

Deleting a record

Before Delete
I will delete one of the records.
Figure 17.jpg
Figure 18.jpg
Figure 19.jpg
Viewing Employees from the Department
Figure 20.jpg
Details of selected Employee
Figure 21.jpg