Filling a WPF Treeview Recursively From a Database in an MVVM Pattern

See more:

C#

WPF

treeview

MVVM

I have used Josh Smith's article, "Simplifying the WPF TreeView by Using the ViewModel Pattern", to adapt his technique to a WPF, MVVM, Prism, Unity type application. It works great when I use his sample "hardcoded" data source provided in his download called "TreeVeiwWithViewModelDemo", but I am stumped on how to modify the code in order to recursively add data to the Person object from a SQL Server database. I am hoping that somebody has already done that and can give me a push in the right direction.

Josh's code is as follows:

public static Person GetFamilyTree()
{
    // In a real app this method would access a database.
    return new Person
    {
        Name = "David Weatherbeam",
        Children =
        {
            new Person
            {
                Name="Alberto Weatherbeam",
                Children=
                { etc...

I need to modify this to access a database and return the list Person which is defined as follows:

public class Person
{
    readonly List<Person> _children = new List<Person>();
    public IList<Person> Children
    {
        get { return _children; }
    }

    public string Name { get; set; }
}

... and the WPF item template looks like this:

<TreeView.ItemTemplate>
  <HierarchicalDataTemplate ItemsSource="{Binding Children}">
    <TextBlock Text="{Binding Name}" />
  </HierarchicalDataTemplate>
</TreeView.ItemTemplate>