Last post Jan 14, 2008 09:51 AM by Brad Engels
Jan 14, 2008 09:51 AM|Brad Engels|LINK
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.
I have table [Issue] and table [User]. [Issue] has fields issue_creator_id and issue_assigned_id, both related to [User].
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.
Other than creating a different User table in the dbml for each time I have multiple foreign keys, what can I do?