Jump to content

Check out our Community Blogs

Register and join over 40,000 other developers!

Recent Status Updates

View All Updates

- - - - -


asp.net mvc

  • Please log in to reply
No replies to this topic

#1 Tyrsius


    CC Lurker

  • Just Joined
  • Pip
  • 9 posts

Posted 03 June 2011 - 11:21 AM

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.

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?
  • 0

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download