SQLite EF Style Migrations

!ReadMe

Note: IFileService is not completely necessary unless you’re doing Xamarin Forms and need.

ApplicationDbContext

public class ApplicationDbContext : SQLiteConnection
{
	public ApplicationDbContext(IFileService fileService) : base(fileService.GetLocalFilePath("[db_file].sqlite"), false)
	{
		CreateTable<MigrationHistory>();
		CreateTable<[YourTable]>();
		RunMigrations();
	}

	private void RunMigrations()
	{
		var typeInfo = typeof(IDbMigration).GetTypeInfo();
		var migrations = typeInfo.Assembly.GetLoadableTypes()
			.Where(x => x.Namespace == typeInfo.Namespace &&
			x.GetTypeInfo().DeclaredConstructors.Any() &&
			typeInfo.IsAssignableFrom(x.GetTypeInfo()))
			.Select(x => (IDbMigration)Activator.CreateInstance(x, this))
			.OrderBy(x => x.Id);

		if (!migrations.Any()) return;

		var lastMigration = MigrationHistories().OrderByDescending(x => x.MigrationId).FirstOrDefault();
		var found = lastMigration == null;
		foreach (var dbMigration in migrations)
		{
			if (!found && dbMigration.Name != lastMigration.Name) continue; //skip till we find last ran migration
			if (!found) //skip found migration
			{
				found = true;
				continue;
			}

			dbMigration.Up();

			Insert(new MigrationHistory
			{
				MigrationId = dbMigration.Id,
				Name = dbMigration.Name
			});
		}
	}
}