title: Select all records from 2 tables - many-to-many EF C#
body: <p>I have 2 tables in my MVC 5 application</p>
  
  <pre><code>public class Customer
  {
      public int Id { get; set; }
  
      public string Name { get; set; }
  
      public DateTime? Birthdate { get; set; }
  }
  
  public class Movie
  {
      public int Id { get; set; }
  
      public string Name { get; set; }
  
      public DateTime ReleaseDate { get; set; }
  }
  </code></pre>
  
  <p>And joint table <strong>Rentals</strong> for many-to-many relationship</p>
  
  <pre><code>public class Rental
  {
      public int Id { get; set; }
  
      [Required]
      public Customer Customer { get; set; }
  
      [Required]
      public Movie Movie { get; set; }
  
      public DateTime? DateReturned { get; set; }
  }
  </code></pre>
  
  <p>Rental table looks like this when populated (just IDs from both Movie and Customer PKs):</p>
  
  <p><a href="https://i.stack.imgur.com/p48n9.jpg" rel="nofollow noreferrer">Table Rental</a></p>
  
  <p>How to select all records (just lets say customer name and all his movies) into one table from those 2 tables (or one joint Rental) in my  HomeController to View?</p>