title: How to write a join var datacontext?
body: <pre><code>DataContext db = new DataContext(conString);
  var dvd = db.GetTable&lt;DvdList&gt;();
  var category = db.GetTable&lt;CategoryList&gt;();
  var query= from b in dvd 
             join category on dvd.CategoryId equals category.CategoryId  
             where b.Title.Contains(txtSearch.Text)
             select b;
  GridView1.DataSource =query;
  </code></pre>
  
  <p>here has error "join category on dvd"</p>