Interface IDbAccessor

Namespace

Quartz.Impl.AdoJobStore

Assembly

Quartz.dll

Service interface or modifying IDbCommand parameters and resultset values.

public interface IDbAccessor

Methods

AddCommandParameter(DbCommand, string, object?, Enum?, int?)

Adds a parameter to IDbCommand.

void AddCommandParameter(DbCommand cmd, string paramName, object? paramValue, Enum? dataType = null, int? size = null)

Parameters

cmd DbCommand

Command to add parameter to

paramName string

Parameter's name

paramValue object

Parameter's value

dataType Enum

Parameter's data type

size int?

Parameter's optional size

GetBooleanFromDbValue(object)

Gets the boolean value from db presentation. Subclasses can overwrite this behaviour.

bool GetBooleanFromDbValue(object columnValue)

Parameters

columnValue object

Value to map from database.

Returns

bool

GetDateTimeFromDbValue(object)

Gets the date/time value from db presentation. Subclasses can overwrite this behaviour.

DateTimeOffset? GetDateTimeFromDbValue(object columnValue)

Parameters

columnValue object

Value to map from database.

Returns

DateTimeOffset?

GetDbBooleanValue(bool)

Gets the db presentation for boolean value. Subclasses can overwrite this behaviour.

object GetDbBooleanValue(bool booleanValue)

Parameters

booleanValue bool

Value to map to database.

Returns

object

GetDbDateTimeValue(DateTimeOffset?)

Gets the db presentation for date/time value. Subclasses can overwrite this behaviour.

object? GetDbDateTimeValue(DateTimeOffset? dateTimeValue)

Parameters

dateTimeValue DateTimeOffset?

Value to map to database.

Returns

object

GetDbTimeSpanValue(TimeSpan?)

Gets the db presentation for time span value. Subclasses can overwrite this behaviour.

object? GetDbTimeSpanValue(TimeSpan? timeSpanValue)

Parameters

timeSpanValue TimeSpan?

Value to map to database.

Returns

object

GetTimeSpanFromDbValue(object)

Gets the time span value from db presentation. Subclasses can overwrite this behaviour.

TimeSpan? GetTimeSpanFromDbValue(object columnValue)

Parameters

columnValue object

Value to map from database.

Returns

TimeSpan?

PrepareCommand(ConnectionAndTransactionHolder, string)

Prepares a IDbCommand to be used to access database.

DbCommand PrepareCommand(ConnectionAndTransactionHolder cth, string commandText)

Parameters

cth ConnectionAndTransactionHolder

Connection and transaction pair

commandText string

SQL to run

Returns

DbCommand