title: Linq to Sql Foreign key relationships
body: <p>Table name: <code>Author</code></p>
  <ul>
  <li>AuthorID -&gt; primary key</li>
  <li>FirstName</li>
  <li>LastName</li>
  </ul>
  <p>Table name: <code>Titles</code></p>
  <ul>
  <li>ISBN -&gt; primary key</li>
  <li>BookTitle</li>
  <li>EditionNumber</li>
  <li>CopyRight</li>
  </ul>
  <p>Table name: <code>AuthorISBN</code></p>
  <ul>
  <li>ISBN -&gt; foreign key</li>
  <li>AuthorID -&gt; foreign key</li>
  </ul>
  <p>How come the below code block below does not trigger the intellisense, since Linq-to-SQL automatically creates properties based on foreign-key relationship? In my case it doesn't...</p>
  <p>ERROR:</p>
  <blockquote>
  <p><em>The name title does not exist in current context in title.AuthorISBN</em></p>
  <p><em>It's not letting me add a photo, but 'Author' has 'one-to-many' relationship with AuthorISBN, and 'Titles' also has 'one-to-many' relationship with AuthorISBN</em></p>
  </blockquote>
  <p>Code:</p>
  <pre><code> BooksDataContext database = new BooksDataContext();
   var authorsAndTitles =
            from title in database.Titles
            from book in title.AuthorISBN
            let author = book.Author
            orderby author.LastName, aurthor.FirstName, title.BookTitle
            select new { author.FirstName, author.LastName, title.BookTitle };
  </code></pre>