Update Records
To update records in a table, use the Update
method of the Table
class. This method updates all records that match a filter. You can update all of the columns for the record, or just some of them.
In Create Tables, a table was introduced that stored a reference and a last modified date. This sample code updates a single record in that table:
docs.Update( docs.Column("Reference") == @"C:\data\file1.txt", new Record().Add("LastModified", DateTime.Now));
The first argument is a filter that selects all records with the given reference. The second argument is a record. Any fields set in this record are set in matching records in the table, while any fields that are not set are ignored. In the example above, only the “LastModified” field is set, so that is updated and the Reference is not changed.