Table of Contents

Class SqlServerDelegate

Namespace
Quartz.Impl.AdoJobStore
Assembly
Quartz.dll

A SQL Server specific driver delegate.

public class SqlServerDelegate : StdAdoDelegate, IDriverDelegate, IDbAccessor
Inheritance
SqlServerDelegate
Implements
Inherited Members

Properties

AdditionalLikeWildcards

T-SQL reads [ as the start of a character class in a LIKE pattern, so a filter asking for a name containing [a-z] would match by class here and literally everywhere else.

protected override string AdditionalLikeWildcards { get; }

Property Value

string

SchemaResourceName

The embedded script that creates this dialect's schema, or null when this delegate has none.

protected override string? SchemaResourceName { get; }

Property Value

string

Remarks

Null on StdAdoDelegate itself, because there is no dialect-neutral DDL: the six shipped delegates each name their own script, and a delegate written outside Quartz names one or leaves provisioning unavailable. Overriding it is the whole of what a delegate has to do to support CreateIfMissing.

The name is a manifest resource name, looked for in the assembly of the delegate's own type and then in each assembly up its base chain. So a delegate of somebody else's can embed a script of its own beside itself, and one that subclasses a shipped dialect delegate to change a statement or two inherits that dialect's script rather than having to carry a copy.

Methods

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

Adds a parameter to IDbCommand.

public override 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

GetRowLimit(int)

SQL Server names its row limit in the projection: SELECT TOP n ….

protected override SqlRowLimit GetRowLimit(int count)

Parameters

count int

Returns

SqlRowLimit
Edit this page