ASP.NET MVC View friendly name for foreign key

Question

On my index/list view I have a list of records from the database, currently they display the foreign key id, I would like to change this so that it displays the text name column of the reference table.

I can't seem to find any examples on this, am I missing something really simple?

Answer 1

In your view, instead of saying:

<%= Html.Encode(Model.ID) %>

Say:

<%= Html.Encode(Model.MyFriendlyName) %>

If you are looking up the name from the foreign table, and you are using an ORM like Linq to SQL, the most likely possibility is something like this:

<%= Html.Encode(Model.MyForeignTable.MyFriendlyName) %>

Of course, I am making a lot of assumptions. If you can provide more detail as to what is in your View, Controller, and Model, I can be more precise.