problem when table a has multiple references to table employ
Posted: Thu 01 Oct 2009 02:58
I'm using the entity framework (edmx)
I have a table A that has 8 references to an employee table. The references are for things like
created by user
last changed by user
manager to approve
person who signed off on plan
person who executed plan
etc.
in the edmx model for table A I have right clicked on each reference and change the name
EMPLOYEEMANAGER for example
I use setlink to update and the correct reference is stored in the database
however when I query the data back in with
query = From p In _
Me.m_ADOService.A.Expand("EMPLOYEECREATEDBY").Expand("EMPLOYEELASTCHANGEDBY").Expand("EMPLOYEEBDN").Expand("EMPLOYEEPARTS").Expand("EMPLOYEEMANAGER").Expand("EMPLOYEEPLANSENT") _
Where p.OI = 123 Select p
None of the employee references are loaded
any suggestions?
I have a table A that has 8 references to an employee table. The references are for things like
created by user
last changed by user
manager to approve
person who signed off on plan
person who executed plan
etc.
in the edmx model for table A I have right clicked on each reference and change the name
EMPLOYEEMANAGER for example
I use setlink to update and the correct reference is stored in the database
however when I query the data back in with
query = From p In _
Me.m_ADOService.A.Expand("EMPLOYEECREATEDBY").Expand("EMPLOYEELASTCHANGEDBY").Expand("EMPLOYEEBDN").Expand("EMPLOYEEPARTS").Expand("EMPLOYEEMANAGER").Expand("EMPLOYEEPLANSENT") _
Where p.OI = 123 Select p
None of the employee references are loaded
any suggestions?