Navigation Property Grief
-
Hey All, I have a seemingly simple situation with a parent-child relation (1 to Many) between a contact table and an email address table. There is FK constraint on the email table. When trying to populate the WPF data grid I’m able to grab information from the contact table but not the email address table. I’ve provided my code to see if a fresh set of eyes can quickly point out what I’m missing. Thanks. TD
'Grab OrgID from select organization in combobox
Dim selectedOrg As tblOrganization = CType(cboOrgList.SelectedItem, tblOrganization)
Dim selectedOrgID As Integer = selectedOrg.idkOrganization'Create contact collection for the contact data grid
Dim contactQuery As ObjectQuery(Of tblContact) = From c In yeslerContext.tblContacts.Include("tblContactEmail") _
Where c.tblOrganization.idkOrganization = selectedOrgID _
Select c
Me.dgContacts.ItemsSource = contactQuery.ToList()dg:DataGrid.Columns
<dg:DataGridTextColumn Header="First" Binding="{Binding Path=vchFirstName}"/>
<dg:DataGridTextColumn Header="Last" Binding="{Binding Path=vchLastName}"/>
<dg:DataGridTextColumn Header="Initials" Binding="{Binding Path=vchInitials}"/>
<dg:DataGridTextColumn Header="Email" Binding="{Binding Path=vchEmail}"/>
<dg:DataGridTextColumn Header="Start Date" Binding="{Binding Path=sdtStartDate}" />
</dg:DataGrid.Columns>