title: Does SQLite support transactions across multiple databases?
body: <p>I've done some searching and also read the FAQ on the SQLite site, no luck finding an answer to my question.</p>
  
  <p>It could very well be that my database approach is flawed, but at the moment, I would like to store my data in multiple SQLite3 databases, so that means separate files.  I am very worried about data corruption due to my application possibly crashing, or a power outage in the middle of changing data in my tables.</p>
  
  <p>In order to ensure data integrity, I basically need to do this:</p>
  
  <pre><code>begin transaction
  modify table(s) in database #1
  modify table(s) in database #2
  commit, or rollback if error
  </code></pre>
  
  <p>Is this supported by SQLite?  Also, I am using sqlite.net, specifically the latest which is based on SQLite 3.6.23.1.</p>
  
  <p><strong>UPDATE</strong></p>
  
  <p>One more question -- is this something people would usually add to their unit tests?  I always unit test databases, but have never had a case like this.  And if so, how would you do it?  It's almost like you have to pass another parameter to the method like bool test_transaction, and if it's true, throw an exception between database accesses.  Then test after the call to make sure the first set of data didn't make it into the other database.  But maybe this is something that's covered by the SQLite tests, and should <em>not</em> appear in my test cases.</p>