Change Select statements generated for generating gridview in Dynamic Data?

Question

I am using ASP.net Dynamic Data scaffolding. I realize that for a table like

table1: EducationLevel (id,levelname,modby,modon)

table2: Course(id,coursename,modby,modon,belongsToEduLevel)

where belongsToEduLevel is the FK. In this case dynamic data never shows levelname in the grid instead, it shows

Operations | Modon | EducationPrograms

How do I change this?? Can I modify the select statement generated.

Answer 1

If I understand you correctly the column you want to be displayed in not being displayed, you want the FK column to be displayed not the text value?

If so all you need to do is apply the DisplayColumn to the table that the FK references and slecte the PK as the column you want to display.

i.e. [DisplayColumn("Id")]

Id is the name of the column to display in FK relationships and Filters.