title: Hierarchical data in a drop-down list on Dynamic Data site
body: <p>I'm getting into dynamic data sites (remarkably powerful), and enjoying it. However, I have a requirement that I can't seem to meet. I have a self-joined category table (Id, Name, ParentId) to create a hierarchical category structure (e.g. the categories with null ids are top level, usual sort of thing). I then have a products table that has a foreign key to the category.</p>
  
  <p>Within the dynamic data site, I have the category dropdown list automatically generated; however it just lists all categories in numerical order. What I would like (and what I've coded before, pre-dynamic data) is an indented list, hierarchically arranged list of categories.</p>
  
  <p>Do I replace the existing FilterUserControl? Can I override the PopulateListControl method anywhere? Does anyone have any LINQ syntax for extract self-joined hierarchical data?</p>
  
  <p>Just pointers and advice would do, thank you for any help offered.</p>
  
  <p>Kind regards,</p>
  
  <p>Mike Kingscott</p>