problem when table a has multiple references to table employ

problem when table a has multiple references to table employ

Postby 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?
estern
 
Posts: 19
Joined: Tue 27 Jan 2009 18:59

Postby 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.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to dotConnect for Oracle