public void SchemaMigration_DeleteUnusedColumns()
{
using (var db = new SQLiteDatabase(":memory:"))
{
db.SynchronizeSchema <Customer1>();
var table = db.GetTable("Customer");
Assert.AreEqual(nameof(SQLiteColumnType.INTEGER), table.GetColumn("Id").Type);
Assert.AreEqual(nameof(SQLiteColumnType.TEXT), table.GetColumn("Name").Type);
var saveOptions = db.CreateSaveOptions();
saveOptions.DeleteUnusedColumns = true;
db.SynchronizeSchema <Customer2>(saveOptions);
table = db.GetTable("Customer");
Assert.AreEqual(3, table.Columns.Count);
Assert.AreEqual(nameof(SQLiteColumnType.INTEGER), table.GetColumn("Id").Type);
Assert.AreEqual(nameof(SQLiteColumnType.TEXT), table.GetColumn("FirstName").Type);
Assert.AreEqual(nameof(SQLiteColumnType.TEXT), table.GetColumn("LastName").Type);
}
}