problem when table a has multiple references to table employ

estern · Post by **estern** » 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?

AndreyR · Post by **AndreyR** » Fri 02 Oct 2009 13:27

There are several known issues concerning Associations renaming in Sliverlight like this one:
http://forums.silverlight.net/forums/p/ ... 67359.aspx
So, I'm not sure the problem is Devart-specific.
Can you please try exactly the same scenario with SQL Server?
If the problem is not reproducible using a Microsoft product, please let us know.