AddColumn

AddColumn allows you to add a new column to an existing table. For example, if you added a new property to the TwitterUser class to record the user’s age, you would then need to use the DatabaseSchemaUpdater to create a new column to store the Age value. This could be achieved in the following manner:

Click here to view code image

using (DataContext dataContext
            = new TwitterDataContext("isostore:Twitter.sdf"))
{
    DatabaseSchemaUpdater updater
                  = dataContext.CreateDatabaseSchemaUpdater();
    updater.AddColumn<TwitterUser>("Age");
    updater.Execute();
}

The database does not change to reflect updates from the DatabaseSchemaUpdater until its Execute method is called, at which point all changes are submitted to the local database as a single transaction, which ensures the database maintains integrity if it is interrupted, such as when the user exits the app during an upgrade.