Hi, I'm looking to to use this great project in a metro style app, and
would like to open an already-created file as a read-only database. I have
no problem opening it in general, but I'm unclear on how to make the
connection read-only.

(As a note, I never intend to write to a database in this project, so
changes to the source code that could affect all databases used are ok)

Hi (unknown),

If you still need this.

Assuming that you are using the ADO.Net API to access the db, I've
implemented the "Read Only" parameter (that the C++ implementation has) for
this C# implementation.  You can test it using the code from this
clone http://code.google.com/r/stewartadcock-csharp-sqlite-updates/ - it
works for me with Mono on Mac OS X, and I assume it will work on Windows
with .Net even though I haven't tested that yet.

To connect to a db in read-only mode, add "Read Only=True" to your
connection string, and then connect as normal.  Any attempts to write to
the db will fail.

I have also implemented the SQLite3 "FailIfMissing" parameter.  If set to
true, sqlite will not create an empty db in the case that the specified uri
doesn't exist.  This is also derived from the C++ version's parameter of
the same name, to improve source-level compatibility.

Regards,
Stewart.