[Mono-list] Where does Mono.Data.Sqlite create its database file?

Agro Rachmatullah agro1986 at gmail.com
Mon Apr 28 06:04:10 EDT 2008

Please look at this program:

http://pastebin.com/f100ca875 (mono and os info there)

In short, this program creates an SQLite database, creates a table
inside it, populates the table, and finally reads the rows.

In particular, take note of the connection string:

conn = new SqliteConnection("Data Source=file:supernew.db");

The program works, however I didn't find any "supernew.db" in the
application's directory. Running a full search on my hard disk also
returns no such file. However, running the program for the second time
gives me "table foo already exists" exception, which shows that the
file must exist somewhere! Where is it located and what is it named?

PS: Using "URI=file:supernew.db" as the connection string gives the
expected result. That is, the file "supernew.db" will be created in
the application's directory. However using "URI" for the connection
string is deprecated according to http://www.mono-project.com/SQL_Lite

Thanks a lot

More information about the Mono-list mailing list