Blinq Previewhttp://forums.asp.net/1076.aspxBlinq is a tool for generating ASP.NET websites for displaying, creating, and manipulating data based on database schema. You can provide feedback and ask questions about the Blinq preview in this forum.enCommunityServer 2007 SP1 (Build: 20510.895)Multiple foreign keys between two tableshttp://forums.asp.net/thread/2108361.aspxMon, 14 Jan 2008 14:51:53 GMT4c671506-2930-414c-a40b-8bf57ded5924:2108361Brad Engels0http://forums.asp.net/thread/2108361.aspxhttp://forums.asp.net/commentrss.aspx?SectionID=1076&PostID=2108361<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>