After I drag the db table into dbml and then run the website,
I discover that dropdownboxes are generated automatically at the top of the page.

It seems the dropdownboxes depend on the child table.
The data in the dropdownbox is the first column other than the primary key.

In my case (I have 4 tables: campaign, user, path, marketer):
Campaign depends on user and marketer.
User depends on marketer.
Paths depends on Campaign.
Marketer doesn't depend on any table.

I want to change the data in the dropdownlist so that the dropdownlist in the path page has data of the column campaign_name_EN instead of Campaign_identifier.
How can I do it?
Thanks a lot!!

Hi,

you can use DisplayColumnAttribute to declare which column should be used for displaying the entities.

I create a class2.cs and put it into App_Cod eto try to use this attribute:

 However, I don get the DisplayColumn hint when I enter [D in the file.

[D <------"[DisplayColumn(" does not show up for me to use
public partial class Campaign{
}

What's the possible reason about this?

Hi longbcc112 are you running the latest bits?

you can get them here:

1. Download Dynamic Data Runtime
2. Optionaly Download Dynamic Data Futures

 DisplayColumnAttribute is in the System.ComponentModel.DataAnnotations namespace. You need to have it included/using for intellisense to provide it.

This is how your class shoud look like:

using System.ComponentModel.DataAnnotations;

[DisplayColumn("Campaign_Name_EN")]
public partial class Campaign
{
}

I hope this helps.

Maíra