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
ClosingQuote ]
DefaultSchema null
IsAffectedRowsSupported true
IsDirectionSupported false
IsExecuteReaderDisposable true (false when constructed by SqliteBootstrap)
IsMultiStatementExecutable true
IsInsertAllBatchable true
IsPreparable true
IsTransactionSupported true
IsUseUpsert true
RequiresDbTypeBeforeValue false
SkipsUnreferencedParameters false
MaxParameterCount 999
MultiStatementSeparator ;
OpeningQuote [
ParameterPrefix @
SqlTextParameterPrefix @

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);