SqLiteDbSetting

A setting class used for the SQLite data provider.

This class is the BaseDbSetting-derived implementation for SQLite. It is automatically registered by SqliteBootstrap — you do not need to instantiate it directly under normal use.

Configured Values

Property Value
AreTableHintsSupported false
AverageableType double
ClosingQuote ]
DefaultSchema null
IsDirectionSupported false
IsExecuteReaderDisposable true (false when constructed by SqliteBootstrap)
IsMultiStatementExecutable true
IsPreparable true
IsUseUpsert true
OpeningQuote [
ParameterPrefix @

The constructor accepts an isExecuteReaderDisposable flag (defaults to true). SqliteBootstrap explicitly passes false, since the Microsoft.Data.Sqlite reader it pairs with should not be treated as disposable in that flow.

Usability

Use DbSettingMapper to override it with a custom implementation.

DbSettingMapper.Add(typeof(SqliteConnection), new MyCustomSqLiteDbSetting(), true);