title: How to restore a SQLite database while an open connection exists?
body: <p>I am writing a plugin for a C# application which uses SQLite database. The initial database is stored in database.db.default. At any point during runtime the user should be able to reset the database to the default content.</p>
  
  <p>Since the application has always an open connection to the database I can not just copy database.db.default to database.db.</p>
  
  <p>Whether or not it is a good idea to always hold an open connection is a total different question. But that is just how it is since it is not my call to change that part of the application.</p>
  
  <p>Is there any way I am able to restore database.db.default into database.db using C# and .NET 3.0?</p>
  
  <p>I appreciate any kind of help ...</p>