Articles → .NET → View Selective Tables In Asp.Net Dynamic Data

View Selective Tables In Asp.Net Dynamic Data

So far we have learnt how to create dynamic data website but what if we do not want to see all the tables? Is there a way to display only selected tables? The answer is yes, and we will show you how.

Objective Of This Tutorial

The previous tutorial demonstrated a basic example of a dynamic data driven application that can be created using ‘ASP .NET Dynamic Data’. In this tutorial we will see how to display selective tables.

Prerequisites

Software

Visual studio 2010 is installed on your machine.

Technical knowledge

In order to understand this tutorial you should know how to create basic asp.net dynamic data application.

Steps Involved

In order to achieve our goal we will be following these steps:

Create a new project of type ‘ASP.NET Dynamic Entities Web Application’
Add code to global.asax
Making changes in the Section class so that it can be displayed
Run the application

Let us work on each step.

Step 1: Create A New Project Of Type ‘ASP.NET Dynamic Entities Web Application’

The first step is to create a new project of type ASP.NET Dynamic Entities Web Application as we have done in the last tutorial of dynamic data and add ASP.NET entity data model in it.

Step 2: Add Code To Global.Asax

For this tutorial we will work on displaying only ‘Section’ table. Open ‘MyDynamicDataApp’ project .Go to the global.asax file and change the code to.

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

‘ScaffoldAllTables’ is an interesting property. It resides in System.ComponentModel.DataAnnotations; namespace. When there is a need to render all the tables, this property is set to true. However, when we don’t want to see some of the tables from the database, then we set this control to ‘false’ as shown above.

Now, in the code above we have set default value of ‘ScaffoldAllTables’ to ‘false’ therefore we will now have make changes in the entity class that we want to display and the required tables can be rendered on the page. We explain this in our next step.

Step 3: Making Changes In The Section Class So That It Can Be Displayed.

We want to display the details of ‘Section’ table. So, we now go to code behind of entity framework and find the ‘Section’ class and add the following piece of code on top.

[ScaffoldTable(true)]

So class code will now be as follows:

[EdmEntityTypeAttribute(NamespaceName = "DynamicDataModel", Name = "Section")]
[Serializable()]
[DataContractAttribute(IsReference = true)]
[ScaffoldTable(true)]
public partial class Section: EntityObject {}

Step 4: Run The Application

The following output will be displayed:

Picture showing the output of Viewing selective tables in asp.net dynamic data

Click to Enlarge

Posted By -	Karan Gupta

Posted On -	Tuesday, April 1, 2014

Query/Feedback

Your Email Id		**

Subject		*

Query/Feedback	Characters remaining 250	**