Method UpdateRecords

Namespace

YndigoBlue.Velocity.Engine

Assembly

YndigoBlue.Velocity.dll

UpdateRecords(Update)

Updates one or more records in a table based on specified criteria.

public void UpdateRecords(Update update)

Parameters

update Update

An Update object defining which records to update and what values to set.

Examples

using (var m = new Manager(conn))
{
    var schema = m.LoadSchema("app");
    var usersTable = schema["users"];

    // Create an update operation
    var update = new Update(usersTable);
    update.Set(usersTable["last_login"], DateTime.Now);
    update.Set(usersTable["login_count"], usersTable["login_count"] + 1);
    update.AddWhere(usersTable["email"], Operator.Equals, "john@example.com");

    m.UpdateRecords(update);
    Console.WriteLine("User updated");
}

Exceptions

DbException

Thrown when a database error occurs.