Insert Records
After you have created a datastore table, you can add records to it:
Record record = new Record(); record["Reference"] = @"C:\data\file1.txt"; record.Add("LastModified", new DateTime( 2013, 8, 05, 18, 05, 0, DateTimeKind.Utc)); docs.Insert(record);
This example creates a record, sets values for each column, and inserts the record into the table created in Create Tables. Add
method for setting DateTime and integer values. DateTimes and integers are converted to string representations automatically when you are setting the value of a text column. You can only set integers in a numeric column.
Although you can set any fields you like in the Record, an exception is thrown from the Insert
method if you try to set fields that are not in the table.
You can create a record and insert it in a single statement, like this:
docs.Insert(new Record() .Add("Reference", @"C:\data\file2.txt") .Add("LastModified", new DateTime( 2013, 7, 30, 14, 36, 0, DateTimeKind.Utc)));