dotConnect for SQLite Documentation
Devart.Data.SQLite Namespace / SQLiteConnectionStringBuilder Class
Properties Methods

In This Topic
SQLiteConnectionStringBuilder Class Members
In This Topic

The following tables list the members exposed by SQLiteConnectionStringBuilder.

Public Constructors
 NameDescription
Public ConstructorSQLiteConnectionStringBuilder ConstructorOverloaded. Initializes a new instance of the SQLiteConnectionStringBuilder class.  
Top
Public Properties
 NameDescription
Public PropertyAttachGets or sets the list of databases to attach.  
Public PropertyAutomaticIndexDetermines whether the SQLite automatic indexing is enabled.  
Public PropertyAutoVacuumDetermines what happens when a transaction that deletes data from a database is committed.  
Public PropertyBinaryGUIDGets or sets a value that determines how GUIDs are stored.  
Public PropertyBusyTimeoutSets an SQLite busy handler that sleeps for a specified amount of time when a table is locked. The handler will sleep multiple times until at least the specified number of milliseconds of sleeping have accumulated. After this the handler returns 0.  
Public PropertyCacheSizeGets or sets the maximum number of database disk pages that SQLite will hold in memory at once.  
Public PropertyCacheSpillGets or sets a value indicating whether to allow spilling dirty cache pages to the database file in the middle of a transaction.  
Public PropertyCaseSensitiveLikeGets or sets a value indicating whether LIKE comparisons should be case-sensitive.  
Public PropertyCellSizeCheckGets or sets a value indicating whether to perform additional checks on database b-tree pages as they are initially read from disk.  
Public PropertyCheckpointFullFSyncDetermines whether the F_FULLFSYNC syncing method is used during checkpoint operations on systems that support F_FULLFSYNC.  
Public PropertyConnectionLifetimeGets or sets time span in seconds for connection to live.  
Public PropertyConnectionStringGets or sets the connection string associated with the System.Data.Common.DbConnectionStringBuilder. (Inherited from System.Data.Common.DbConnectionStringBuilder)
Public PropertyConnectionTimeoutGets or sets the time to wait while trying to establish a connection before terminating the attempt and generating an error.  
Public PropertyCountGets the current number of keys that are contained within the System.Data.Common.DbConnectionStringBuilder.ConnectionString property. (Inherited from System.Data.Common.DbConnectionStringBuilder)
Public PropertyCountChangesGets or sets a value indicating whether the database engine should return the number of inserted, updated, or deleted rows.  
Public PropertyDataSourceGets or sets the location of the database.  
Public PropertyDateTimeFormatGets or sets the format of DATETIME values.  
Public PropertyDefaultCommandTimeoutGets or sets the time in seconds to wait while trying to execute a command before terminating the attempt and generating an error.  
Public PropertyEnableLoadExtensionGets or sets a value indicating whether an SQLite extension library can be loaded from the from the named file with the statement SELECT load_extension(file_name);. It can be useful, for example, for the full-text search modules.  
Public PropertyEncryptionDetermines whether the database is encrypted and kind of the database encryption.  
Public PropertyEncryptionLicenseKeyGets or sets the license key of the SQLCipher or SQLiteCrypt extension. Set this parameter if you are connecting to SQLCipher or SQLiteCrypt encrypted databases.  
Public PropertyEnlistGets or sets a Boolean value that indicates whether the connection is automatically enlisted in the current transaction context.  
Public PropertyFailIfMissingGets or sets the value that determines what to do when the database file is missing.  
Public PropertyForeignKeyConstraintsDetermines whether the foreign key constraints are enforced.  
Public PropertyFullColumnNamesGets or sets a value that determines the format of autogenerated names.  
Public PropertyFullFSyncGets or sets a value that determines whether or not the F_FULLFSYNC syncing method is used on systems that support it.  
Public PropertyIgnoreCheckConstraintsDetermines whether the check constraints are enforced.  
Public PropertyInitializationCommandSpecifies a data source-specific command that should be executed immediately after establishing the connection. (Inherited from Devart.Common.DbConnectionStringBuilder)
Public PropertyIsFixedSizeOverridden. Returns true.  
Public PropertyIsReadOnlyGets a value that indicates whether the System.Data.Common.DbConnectionStringBuilder is read-only. (Inherited from System.Data.Common.DbConnectionStringBuilder)
Public PropertyItemOverridden. Returns the value of given key.  
Public PropertyJournalModeDetermines SQLite journal mode for the connection.  
Public PropertyJournalSizeLimitGets or sets the maximal size of the log file in bytes.  
Public PropertyKeysOverridden. Collection of keys in the SQLiteConnectionStringBuilder.  
Public PropertyLegacyFileFormatGets or sets a value that indicates backwards compatibility of the database file.  
Public PropertyLoadExtensionDefines the list of SQLite extension libraries, which are loaded when the connection opens. Applied only when the EnableLoadExtension connection string parameter is set to True.  
Public PropertyLockingGets or sets a value that determines database locking mode.  
Public PropertyMaxPageCountGets or sets the maximum number of pages in the database file.  
Public PropertyMaxPoolSizeThe maximum number of connections allowed in the pool.  
Public PropertyMinPoolSizeThe minimum number of connections allowed in the pool.  
Public PropertyPageSizeGets or sets the page size in newly created databases.  
Public PropertyPasswordGets or sets the user's password to connect.  
Public PropertyPersistSecurityInfoGets or sets a value indicating whether password is stored in connection string after connection is opened.  
Public PropertyPoolingGets or sets pooling mode.  
Public PropertyReadOnlyDatabaseDetermines whether to open a database in a read-only mode. An exception is thrown if a database does not exist. Available only if the connection uses the UTF8 encoding - if UTF16 is set to false.  
Public PropertyReadUncommittedGets or sets the process isolation level.  
Public PropertyRecursiveTriggersDetermines whether the recursive triggers are turned on.  
Public PropertyReverseUnorderedSelectsDetermines whether the result of the SELECT statement without the ORDER BY clause will be retrieved in the reverse order of what it normally would.  
Public PropertyRunOnceCommandSpecifies a data source-specific command that should be executed immediately after first establishing the connection. Unlike InitializationCommand, this command is not executed when a connection is taken from the pool. (Inherited from Devart.Common.DbConnectionStringBuilder)
Public PropertySecureDeleteSpecifies whether to overwrite the deleted data with zeroes.  
Public PropertyShortColumnNamesGets or sets a value that determines the format of autogenerated names.  
Public PropertySynchronousGets or sets a value that determines the synchronization mode of write operations.  
Public PropertyTempStoreGets or sets a value that indicates location of temporary files.  
Public PropertyTempStoreDirectoryGets or sets the directory where the temporary files are stored.  
Public PropertyThreadsGets or sets the maximal number of auxillary threads the prepared statement can launch to assist with a query.  
Public PropertyTransactionScopeLocalEnables support for non-distributed transactions in the TransactionScope implementation.  
Public PropertyUTF16Gets or sets a value indicating whether the connection uses UTF16 encoding.  
Public PropertyValidateConnectionIndicates whether to validate connections that are being taken from the pool.  
Public PropertyValuesOverridden. Collection of values in the SQLiteConnectionStringBuilder.  
Public PropertyVersionGets the version of the database engine, always 3.  
Public PropertyWALAutoCheckpointGets or sets the write-ahead log auto-checkpoint interval.  
Public PropertyWritableSchemaDetermines whether the SQLITE_MASTER tables can be changed using UPDATE, INSERT, and DELETE statements.  
Top
Public Methods
 NameDescription
Public MethodAddAdds an entry with the specified key and value into the System.Data.Common.DbConnectionStringBuilder. (Inherited from System.Data.Common.DbConnectionStringBuilder)
Public MethodClearOverridden. Sets all SQLiteConnectionStringBuilder properties to default values.  
Public MethodContainsKeyOverridden. Indicates whether specified key is set in the SQLiteConnectionStringBuilder object.  
Public MethodEquivalentToOverloaded. Overridden. Returns a value indicating whether this SQLiteConnectionStringBuilder has same parameters as given DbConnectionStringBuilder.  
Public MethodRemoveOverridden. Sets value of the specified key to default.  
Public MethodShouldSerializeOverridden. Determines whether the key will be serialized if required.  
Public MethodToStringReturns the connection string associated with this System.Data.Common.DbConnectionStringBuilder. (Inherited from System.Data.Common.DbConnectionStringBuilder)
Public MethodTryGetValueOverridden. Attempts to get a key value.  
Top
See Also

Reference

SQLiteConnectionStringBuilder Class
Devart.Data.SQLite Namespace
ConnectionString Property

 

 

© 2008 - 2025 Devart. All Rights Reserved.

Send Feedback