Multiple join using Entity Framework

Question

I am looking at moving a website from ASP.NET Web Pages to MVC. I need to understand how i do mutliple joins using entity framework.

I currently have 3 database tables with a model for each.

Property
Rooms
RoomType

The code below gets all the info from the rooms table for each property, but it just gives me a RoomTypeID from the Rooms table. What I need is to get the RoomType from the RoomType table using that ID.

@model manage.stayinflorida.co.uk.DataModels.Property_Info

    @foreach (var item in Model.RoomInfoes)
    {
        <tr>
            <td>
                @Html.DisplayFor(modelItem => item.RoomTypeID)
            </td>
            <td>
                @Html.DisplayFor(modelItem => item.RoomDescription)
            </td>
        </tr>
    }

Look for some join examples for entity framework. Also, look at navigation properties... — Luke
– Luke, Commented Dec 15, 2015 at 11:00
Possible duplicate of MVC 5 Multiple Models in a Single View — Khalid Hussain
– Khalid Hussain, Commented Dec 15, 2015 at 11:04

Rob Aston · Accepted Answer · 2015-12-15 11:10:36Z

2

Usually with Entity Framework, you get a Navigation Property on your entities if they have a foreign key relation.

This means you can access the property from the related type as well.

If your RoomInfos class has a property called RoomType of type RoomType (which is linked on the RoomTypeID) you can therefore access this in your model.

An example is shown below - the example is assuming you have a property on 'RoomType' called 'Name'.

@model manage.stayinflorida.co.uk.DataModels.Property_Info

@foreach (var item in Model.RoomInfoes)
{
    <tr>
        <td>
            @Html.DisplayFor(modelItem => item.RoomType.Name)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.RoomDescription)
        </td>
    </tr>
}

See this link for additional information about Navigation Properties.

edited Dec 15, 2015 at 11:10

answered Dec 15, 2015 at 11:04

Rob Aston

81612 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Gavin5511 Over a year ago

This is exactly what i was after, thanks Rob. The link about Navigation Properties is also really useful.

Collectives™ on Stack Overflow

Multiple join using Entity Framework

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related