title: MVC Inner join Linq (begginner question)
body: <p>Hello i have this controller(probably i got it wrong)</p>
  
  <pre><code> public ActionResult Detail(int id)
  {
  
      var detail = from cities in _db.Cities
                   join properties in _db.Properties on cities.CityId equals properties.CityId
                   join proplocations in _db.PropLocations on properties.LocationId equals proplocations.LocationId
                   join proptypes in _db.PropTypes on properties.TypeId equals proptypes.TypeId
                   where properties.PropId == id
                   select new
                   {
                       cities.CityName,
                       proptypes.PropType1,
                       proplocations.Location,
                       properties.PropName,
                       properties.PropOwner,
                       properties.PropStars,
                       properties.PropAddress,
                       properties.PropDescription,
                       properties.MaxGuests,
                       properties.PropConditions,
                       properties.PropId
  
                   };       
  
  
      return View(detail.FirstOrDefault());
  
  }
  </code></pre>
  
  <p>and this EDMX:
  <img src="https://i.stack.imgur.com/TTYT3.jpg" alt="model"></p>
  
  <p>could somebody explain me please how to get the detail of the property view? i tried difference combination but because of my low experience in the field (this is my first try) nothing worked.</p>
  
  <p>Please help me to make this view work
  thank you</p>