title: SQLite PRAGMA foreign_keys question
body: <p>I've modified System.Data.SQLite to use a recent version of <a href="http://en.wikipedia.org/wiki/SQLite" rel="nofollow noreferrer">SQLite</a> engine that automatically enforces foreign keys without using custom triggers. </p>
  
  <p>I'm also using <a href="http://en.wikipedia.org/wiki/Subsonic_%28software%29" rel="nofollow noreferrer">SubSonic</a> 2.x but this would apply to any <a href="http://en.wikipedia.org/wiki/Object-relational_mapping" rel="nofollow noreferrer">ORM</a> frameworks using SQLite that are 'open late close early'.</p>
  
  <p>How would you ensure that the statement 'PRAGMA foreign_keys=true' is called on every SQLiteConnection.Open()? It has to be called or foreign keys don't work.</p>