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
AverageableType double
ClosingQuote ]
DefaultSchema dbo
IsDirectionSupported true
IsExecuteReaderDisposable true
IsMultiStatementExecutable true
IsPreparable true
IsUseUpsert false
OpeningQuote [
ParameterPrefix @

Usability

Use DbSettingMapper to override it with a custom implementation.

DbSettingMapper.Add(typeof(SqlConnection), new MyCustomSqlServerDbSetting(), true);