title: How do I search multiple tables in an MVC application?
body: <p>I have 2 tables (<code>Topics</code> and <code>Comments</code>) in an MVC application.  I would like to query the <code>comments</code> table, but also return the <code>title</code> from the <code>topic</code> table.</p>
  
  <p>I believe I'm using EF.  I would use SQL, but I'm not sure if that is possible for an MVC application.</p>
  
  <p>Using SQL I would do the following:</p>
  
  <pre><code>SELECT c.Id, c.Comment, t.Title 
  FROM Comments c INNER JOIN Topics t
  ON c.TopicId = t.Id
  </code></pre>
  
  <p>Any help is appreciated.</p>