No replies to this topic

[Tyrsius]

This may be the wrong forum to post in, but I am having trouble finding the right one. I am working on a web app using MVC2, and I am connecting to a sql server with ADO Entity.

In C#, you can look up foreign keys using relations. This is helpful, because the database I am working on has related tables, but the FK isn't actually defined in them (and I cannot change this). I use relations to look up information.

Example:
Issue table contains a column for company, which stores the ID.
Company table has a PK and a name column.

I use a relation between the Issue table's company_ID and the company table's PK, and the relation will give me the name. I know this is kind of basic, but I don't want to confuse anyone when I ask the question.

In ADO's Entity Data Model, what is the equivalent of these data relations? How do I map a table column to another table column?