[RESOLVED] RIA Include Related Tables

[MattP]

I'm having an issue getting related tables to show up where I have multiple one-to-many relationships and getting them to show up using a LinqToEntitiesDomainService. (See attached image)

Here's my code for retrieving my entities:

Public Function GetLoansByLoanID(ByVal LoanID As Integer) As IQueryable(Of LoanMaster)
Return Me.Context.LoanMaster _
.Include("Borrower") _
.Include("Borrower.Signer") _
.Where(Function(x) x.LoanID = LoanID)
End Function

Here's the relevant part of my metadata file:

Friend NotInheritable Class LoanMasterMetadata
<Include()> _
Public Borrower As EntityCollection(Of Borrower)

Public EntityState As EntityState
End Class

Friend NotInheritable Class BorrowerMetadata
Public EntityState As EntityState

Public LoanMaster As LoanMaster

<Include()> _
Public Signer As EntityCollection(Of Signer)
End Class

Friend NotInheritable Class SignerMetadata
Public EntityState As EntityState

Public Borrower As Borrower
End Class

Here's the wireup for displaying my loan master entity (which works)

<dataform:DataForm x:Name="LoanDetails" Header="Loan Information"
AutoGenerateFields="False" AutoEdit="False" AutoCommit="False"
ItemsSource="{Binding ElementName=MyData, Path=Data}" HeaderVisibility="Collapsed" MinWidth="640" >

Here's the wireup for displaying my Borrowers entity (which works)

<datagrid:DataGrid x:Name="BorrowerGrid" MinHeight="100" IsReadOnly="True"
ItemsSource="{Binding ElementName=MyData, Path=Data.Borrower}" />

Here's the wirup for displaying my Signers entity (which doesn't work)

<datagrid:DataGrid x:Name="SignerGrid" MinHeight="100" IsReadOnly="True"
ItemsSource="{Binding ElementName=MyData, Path=Data.Borrower.Signer}" />

At this point it appears the issue is with with my Binding because when I step through MyData.DataView.CurrentItem.Borrower.Item(0).Signer.Item(0) in the debugger I'm getting the expected data. I can't figure out which Path to provide to get this to display though.

If anyone could help me out it would be greatly appreciated.

[MattP]

I had to handle the SelectionChanged event of my BorrowerGrid and load the Entities into the DomainContext.

Private Sub BorrowerGrid_SelectionChanged(ByVal sender As System.Object, ByVal e As System.Windows.Controls.SelectionChangedEventArgs)

Me.SignerGrid.ItemsSource = Nothing
ctx.Signers.Clear()

Dim selectedBorrower = CType(BorrowerGrid.SelectedItem, Borrower)
If selectedBorrower IsNot Nothing Then
Dim borrowerID = selectedBorrower.BorrowerID
Me.SignerGrid.ItemsSource = ctx.Signers
ctx.Load(ctx.GetSignersByBorrowerIDQuery(borrowerID))
End If

End Sub