Method DeleteRecords

Namespace

YndigoBlue.Velocity.Engine

Assembly

YndigoBlue.Velocity.dll

DeleteRecords(Delete)

Deletes one or more records from a table based on specified criteria.

public void DeleteRecords(Delete delete)

Parameters

delete Delete

A Delete object defining which records to delete.

Examples

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

    // Delete inactive users
    var delete = new Delete(usersTable);
    delete.AddWhere(usersTable["active"], Operator.Equals, false);
    delete.AddWhere(usersTable["last_login"], Operator.LessThan, DateTime.Now.AddYears(-1));

    m.DeleteRecords(delete);
    Console.WriteLine("Inactive users deleted");
}

Exceptions

DbException

Thrown when a database error occurs.