Class SqlServerProviderOptions
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
trueif 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
trueif 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.