Struct SqlStatement

Namespace

Quartz.Impl.AdoJobStore

Assembly

Quartz.dll

A statement and the parameters bound to it, kept as data rather than issued, so that the same definition can go out either as a standalone command or as one command of a DbBatch.

public readonly record struct SqlStatement : IEquatable<SqlStatement>

Implements

IEquatable<SqlStatement>

Inherited Members

ValueType.Equals(object)

ValueType.GetHashCode()

ValueType.ToString()

object.Equals(object, object)

object.GetType()

object.ReferenceEquals(object, object)

Remarks

The text is what would otherwise have been handed to PrepareCommand(ConnectionAndTransactionHolder, string): the table prefix already substituted, and the parameters still spelled with @. A driver that spells them some other way has its spelling applied when the statement is issued, which is the only point at which the driver is known.

Constructors

SqlStatement(string, List<SqlStatementParameter>)

A statement and the parameters bound to it, kept as data rather than issued, so that the same definition can go out either as a standalone command or as one command of a DbBatch.

public SqlStatement(string Sql, List<SqlStatementParameter> Parameters)

Parameters

Sql string

The statement text.

Parameters List<SqlStatementParameter>

The parameters to bind, in the order the statement mentions them — which is what a driver that binds positionally rather than by name needs.

Remarks

The text is what would otherwise have been handed to PrepareCommand(ConnectionAndTransactionHolder, string): the table prefix already substituted, and the parameters still spelled with @. A driver that spells them some other way has its spelling applied when the statement is issued, which is the only point at which the driver is known.

Properties

Parameters

The parameters to bind, in the order the statement mentions them — which is what a driver that binds positionally rather than by name needs.

public List<SqlStatementParameter> Parameters { get; init; }

Property Value

List<SqlStatementParameter>

Sql

The statement text.

public string Sql { get; init; }

Property Value

string