SqlServerDbSetting
A setting class used for the SQL Server data provider.
This class is the BaseDbSetting-derived implementation for SQL Server. It is automatically registered by SqlServerBootstrap — you do not need to instantiate it directly under normal use.
Configured Values
| Property | Value |
|---|---|
| AreTableHintsSupported | true |
| ClosingQuote | ] |
| DefaultSchema | dbo |
| IsAffectedRowsSupported | true |
| IsDirectionSupported | true |
| IsExecuteReaderDisposable | true |
| IsMultiStatementExecutable | true |
| IsInsertAllBatchable | true |
| IsPreparable | true |
| IsTransactionSupported | true |
| IsUseUpsert | false |
| RequiresDbTypeBeforeValue | false |
| SkipsUnreferencedParameters | false |
| MaxParameterCount | 2098 |
| MultiStatementSeparator | ; |
| OpeningQuote | [ |
| ParameterPrefix | @ |
| SqlTextParameterPrefix | @ |
Usability
Use DbSettingMapper to override it with a custom implementation.
DbSettingMapper.Add(typeof(SqlConnection), new MyCustomSqlServerDbSetting(), true);