Method AddRecordNoIdentity

Namespace

YndigoBlue.Velocity.Engine

Assembly

YndigoBlue.Velocity.dll

AddRecordNoIdentity(Record)

Inserts a single record into a table without returning an identity value (for tables without auto-increment keys).

public void AddRecordNoIdentity(Record record)

Parameters

record Record

The Record object containing the data to insert.

Examples

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

    // Insert a record without needing the ID back
    var record = new Record(logsTable);
    record.SetFieldDateTime("timestamp", DateTime.Now);
    record.SetFieldVarChar("message", "Application started");
    record.SetFieldVarChar("level", "INFO");

    m.AddRecordNoIdentity(record);
}

Exceptions

NoValueForNotNullColumnException

Thrown when a required NOT NULL column has no value.

ValueSetForAutoGeneratedColumnException

Thrown when attempting to set a value for an auto-increment column.

DbException

Thrown when a database error occurs.