title: How do I make LINQ queries to an SQLite database?
body: <p>The <code>System.Data.SQLite</code> namespace includes a sub-namespace, <code>System.Data.SQLite.Linq</code>, which the <a href="http://system.data.sqlite.org/index.html/doc/trunk/www/faq.wiki" rel="nofollow">website</a> claims provides LINQ support. However, I can find no documentation of how to actually use it. In the following piece of code, what kind of object must <code>table</code> be, and how do I create one?</p>
  
  <pre><code>var rows = 
      from row in table
      where row.Id == 4345
      select column1, column2
  </code></pre>