Table of Contents

Class SqlServerProviderOptions

Namespace
Excalibur.Data.SqlServer
Assembly
Excalibur.Data.SqlServer.dll

Configuration options for SQL Server provider.

public sealed class SqlServerProviderOptions
Inheritance
SqlServerProviderOptions
Inherited Members

Properties

CommandTimeout

Gets or sets the command timeout in seconds.

[Range(1, 2147483647)]
public int CommandTimeout { get; set; }

Property Value

int

The command timeout in seconds.

EnableMars

Gets or sets a value indicating whether to enable Multiple Active Result Sets.

public bool EnableMars { get; set; }

Property Value

bool

true if Multiple Active Result Sets (MARS) is enabled; otherwise, false .

Name

Gets or sets the provider name.

public string? Name { get; set; }

Property Value

string

The provider name.

OpenConnectionImmediately

Gets or sets a value indicating whether to open connections immediately.

public bool OpenConnectionImmediately { get; set; }

Property Value

bool

true if connections are opened immediately; otherwise, false .

RetryCount

Gets or sets the retry count for transient failures.

[Range(0, 10)]
public int RetryCount { get; set; }

Property Value

int

The retry count for transient failures.

Remarks

Bounded, because the attempt budget is what bounds the total time a single data request can spend retrying: the backoff delay is capped at thirty seconds, so the worst case is this many attempts of thirty seconds. An unbounded budget left that worst case unbounded too, and a caller observes an unbounded retry as a hung request rather than a failure.