How to bind a binding table to WPF TreeView

Question

What is the best solution for binding self-referncing tables from edmx, for example:

into a WPF control TreeViewto have something like:

Answer 1

I solve the problem using this Binding Converter:

    public object Convert(object value, Type targetType, object parameter, CultureInfo culture)
    {
        var item = value as MyTable;
        return  item.MyTable1.Where(i => i.parent_id== item.id); //return children
    }

.xaml:

<TreeView Name="treeview1" ItemsSource="{Binding Converter={StaticResource HierarchyConverter}}" ItemTemplate="{StaticResource ItemTemplate}" >
      <TreeView.Resources>
            <local:HierarchyConverter x:Key="HierarchyConverter" />
            <HierarchicalDataTemplate x:Key="ItemTemplate" ItemsSource="{Binding Converter={StaticResource HierarchyConverter}}">
                  <TextBlock Text="{Binding element_name}" />
            </HierarchicalDataTemplate>
      </TreeView.Resources>
</TreeView>

.cs:

treeview1.ItemsSource = db.MyTable.Where(x => x.partnt_id== null);//elements that have no parent

Answer 2

Josh Smith has an excellent article in the Code Project article that talks about how to create a presentation model that yours can bind to TreeView. You will not be able to simply use EF because EF does not perform recursion.

Answer 3

ItemsSource .cs xaml . ?! : <local:HierarchyConverter x:Key="HierarchyConverter"/>

Pls, :))