Dynamic Data: how to filter dropdown for foreign key on edit page

.net, dynamic-data, linq-to-sql

Solution

Well, I found a place to customize this, although I still have not found a way to override or extend the linq query for loading the data:

In the file \DynamicData\FieldTemplates\ForeignKey_Edit.ascx.cs (as per default location), in the Page_Load method the following call is made:

PopulateListControl(DropDownList1);

This can be replaced entirely with your own code. In my case, I first checked if the current table implements a custom interface I defined. If it does, use that to get the data to bind the dropdown, else pass control on to PopulateListControl.

Using Reflector, it seems that PopulateListControl ultimately uses MetaTable.GetQuery() to get a default list query for a table. Would have been nice to extent that instead.. but moving on to other things now!

Problem

Using Linq-to-SQL and Dynamic Data. On a Dynamic Data edit screen, a dropdown lists the possible values for a foreign key. I need to filter the values listed in this dropdown, preferably by adding a where clause on the linq-to-sql query. Any ideas?

Original source