Jump to content


Check out our Community Blogs

Register and join over 40,000 other developers!


Recent Status Updates

View All Updates

Photo
- - - - -

ASP.NET and MVC2

asp.net mvc

  • Please log in to reply
No replies to this topic

#1 Tyrsius

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.

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





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