title: how to do a Join in Entity Framework
body: <p>Instead of writing a linq query, is there a way I can just do a join by simply doing something like this:</p>
  
  <pre><code>using (var db = new MatchGamingEntities())
  {
      db.Accounts.Join() //I am unsure of the syntax
      db.Accounts.Include...
      ...
  
      return View(Account.SingleOrDefault());
  }
  </code></pre>
  
  <p>I want to use these predefined Entity functions instead of writing linq, is it practical?  Also how do you use these predefined functions?  I have a table called "Accounts" and "BankTransactions" they both have AccountId in common, How would I query that using these functions and what type of result would it return its one to many relationship.</p>