Yes, this is possible:
- When the application first runs, check if the database file exists.
- If it doesn’t, open it with the Sqlite option
FailIfMissing=False
. This will create a new file.
- Then, use SQL commands like
CREATE TABLE ...
to create the schema structure.
For the second step, I use code that looks something like this:
public DbConnection CreateConnectionForSchemaCreation(string fileName)
{
var conn = new SQLiteConnection();
conn.ConnectionString = new DbConnectionStringBuilder()
{
{"Data Source", fileName},
{"Version", "3"},
{"FailIfMissing", "False"},
}.ConnectionString;
conn.Open();
return conn;
}
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…