If you have 2 tables with 2 foreign keys between the same two db's, it
seems to create an invalid DBML which is not recognized by VS.
An example:
Table1: Order
ShippingUserID (foreign key into User table)
BillingUserID (foreign key into User table)
Table2: User
ID
The code that gets generated is as such:
<Association Name="User_Order1" Member="User" Storage="_user"
ThisKey="ShippingUserID" OtherKey="ID" Type="User"
IsForeignKey="true" />
<Association Name="User_Order" Member="User" Storage="_user"
ThisKey="BillingUserID" OtherKey="ID" Type="User" IsForeignKey="true" /
>
What *should* be generated (I believe, the difference is in the Member
attribute):
<Association Name="User_Order1" Member="User" Storage="_user"
ThisKey="ShippingUserID" OtherKey="ID" Type="User"
IsForeignKey="true" />
<Association Name="User_Order" Member="User1" Storage="_user"
ThisKey="BillingUserID" OtherKey="ID" Type="User" IsForeignKey="true" /
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"DbLinq" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/dblinq?hl=en
-~----------~----~----~----~------~----~------~--~---
