KingMigrations.Sqlite 1.3.0

KingMigrations

A really lightweight and simple database migration library. This is not intended to compete with the more advanced migration frameworks; rather, it's just for when you want something very small and very simple to handle some basic database migrations.

Packages

• KingMigrations
• KingMigrations.Sqlite
• KingMigrations.SqlServer
• KingMigrations.PostgreSql

A quick example

1. Create a migration script (001.sql):

-- Id: 1
-- Description: The first example migration script.

create table table_1 (id integer primary key, value text not null);
create table table_2 (id integer primary key, value text not null);

2. Create another migration script (002.sql):

-- Id: 2
-- Description: The second example migration script.

create table table_3 (id integer primary key, value text not null);
create table table_4 (id integer primary key, value text not null);

3. Run the migrations:

var migrationApplier = new SqliteMigrationApplier();
var migrationSource = new DirectoryMigrationSource("/path/to/your/migration/directory");
migrationSource.AddParser(".sql", new SemicolonDelimitedMigrationParser());

using var connection = InitializeYourSqliteDatabaseConnectionHere();
await connection.OpenAsync();
await migrationApplier.ApplyMigrationsAsync(connection, migrationSource);

License and copyright

Copyright Matthew King. Distributed under the MIT License. Refer to license.txt for more information.