Selecting an entity doesn't subselect associated entities <p>I'm learning ASP.NET MVC (and MVC in general) and all the help online I find only demonstrates using a single table, not relations between multiple tables. I'm running a query that I expect should also return associated entities, but it's not and can't figure out what I'm missing. I appreciate your help!</p> <p>I have the following data:</p> <pre><code>Ticket TicketID CompanyID Subject ... -------- --------- ------- 1 1 "stuff" 2 1 "things" Company CompanyID Name ... --------- -------- 1 "FredCo" </code></pre> <p>So every ticket is linked to a specific company. I am trying to create a Details view for Tickets, and I want to display the company name. Here is what I have set up at the moment.</p> <p><strong>Model</strong></p> <p>A <code>Ticket</code> entity and a <code>Company</code> entity, and there is an association called <code>CompanyTicket</code> between them. The navigational properties are Ticket.Company and Company.Tickets.</p> <p>In the mapping details for the association, I have:</p> <pre><code>Maps to Ticket Company.CompanyID &lt;-&gt; CompanyID Ticket.TicketID &lt;-&gt; TicketID </code></pre> <p><strong>Controller</strong></p> <p>My TicketController.Details method looks like this:</p> <pre><code>public ActionResult Details( int id ) { var tickettoview = ( from m in _db.Ticket where m.TicketID == id select m ).First(); return View( tickettoview ); } </code></pre> <p><strong>Edit</strong>: After going through Mark Hamilton's suggestion, I realize the problem is my query. Putting a breakpoint on the return shows that <code>tickettoview</code> never has Customer populated. So this narrows it down, but I'm still not sure how to populate the Company attribute.</p> <p>Again, thank you!</p>