Creating Sqlite Embedded database from application

Question

I have a winforms app that uses sqlite to store data. Instead of shipping a blank database, can I use scripts to create the tables the first time the user uses the app? Can you point to a C# example?

Update: I want to avoid shipping a blank database. So if a user install the app for 1 user only, only his profile gets a copy. All users profile gets the database if the install is for all users.

You could also create the tables you need and ship the empty database file with the app. — Adam Lear
– Adam Lear ♦, Commented Aug 13, 2010 at 2:15

Timwi · Accepted Answer · 2010-08-13 02:31:43Z

19

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;
}

answered Aug 13, 2010 at 2:31

Timwi

66.8k34 gold badges172 silver badges235 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

B. Clay Shannon-B. Crow Raven Over a year ago

Referencing System.Data.SQLite version 1.0.94.0, DbConnectionStringBuilder is not resolvable.

Huseyin Yagli Over a year ago

@B.ClayShannon : System.Data.Common.DbConnectionStringBuilder

Collectives™ on Stack Overflow

Creating Sqlite Embedded database from application

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related