ConnectionEditor

The connection string specifies the configuration values required to connect to the SQLite database.

To access the Connection Editor, click the … icon in the Connection string property.

Note

Note

• The Connection Editor builds the connection string using a form with the most common properties pre-populated.
• You can add, remove, or rename properties directly in the form.
• Paste an existing connection string into the property field before opening the editor to have it parsed automatically.

Once your connection is set up, you can create and execute SQL queries. See the SQL Editor for details.

Connection string

Data Source=C:\Data\myapp.db

Keyword	Values	Default	Description
Data Source	File path or :memory:	(required)	Absolute path to the .db file, or :memory: for an in-memory database
Mode	ReadWriteCreate, ReadWrite, ReadOnly, Memory	ReadWriteCreate	Controls how the database file is opened
Cache	Default, Private, Shared	Default	Enables connection sharing for in-memory databases
Timeout	Integer (seconds)	30	Maximum time to wait if the database is locked
Password	Any string	(none)	Requires a SQLCipher-compatible library

Caution

Always use absolute paths in Data Source (e.g. C:\Data\myapp.db). Relative paths are not supported.

Links

• SQLite connection strings
• Microsoft.Data.Sqlite connection string reference