http://forums.asp.net/t/1205275.aspx/1?Multiple+foreign+keys+between+two+tablesMon, 14 Jan 2008 13:51:53 -050012052752108361http://forums.asp.net/p/1205275/2108361.aspx/1?Multiple+foreign+keys+between+two+tables <p>I have been working on an issue tracking application and have decided to do my database access using linq. The only real problem I have run into is how to link two tables that have multiple foreign key relations.</p> <p>I have table [Issue] and table [User]. [Issue] has fields issue_creator_id and issue_assigned_id, both related to [User].</p> <p>The problem that I run into is that when I access Issue.User.user_name with linq, I cannot choose between the creator or assigned relationship.</p> <p>Other than creating a different User table in the dbml for each time I have multiple foreign keys, what can I do?</p> 2008-01-14T13:51:53-05:00