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 older than one year
    Filter filter = new Filter();
    filter.Add(new Criterion<bool>(usersTable["active"], false));
    filter.Add(new BooleanItem(BooleanType.And));
    filter.Add(new Criterion<DateTime>(usersTable["last_login"], ConditionalType.LessThan, DateTime.Now.AddYears(-1)));

    var delete = new Delete(usersTable, filter);
    m.DeleteRecords(delete);
    Console.WriteLine("Inactive users deleted");
}

Exceptions

DbException

Thrown when a database error occurs.