A connection string configures how an application connects to a data source. With SQLite, it selects in-memory or file-based storage. An in-memory database disappears when all connections close, so keep a connection open while using it. section 5.3
Connection string
A connection string is a configuration string that specifies how an application connects to a data source and its connection options.
How .NET in Action, Second Edition covers it
- How deep it goes
- Explains SQLite storage selection and the in-memory lifetime caveat, but gives no file-based connection-string example.
- Examples
- Uses `DataSource=manningbooks;mode=memory;cache=shared` and keeps a SQLite connection open.
- What you can do after
- Configure SQLite to use a shared in-memory database and keep it alive with an open connection.
- How it connects
- Connects SQLite configuration with Entity Framework Core and DbContext.
Also explained in
-
Building Web APIs with ASP.NET CoreA connection string is a configuration value that specifies how an application connects to a data source, often including server, database, and credentials.
-
Build Python Web Apps with StreamlitA connection string is a structured value containing the address, port, credentials, and database name needed to connect to a data service.
-
Learn PowerShell Scripting in a Month of Lunches, Second Edition: Write and organize scripts and toolsA connection string is a formatted set of information that identifies a data source and specifies connection and authentication settings.
-
MongoDB 8.0 in Action, Third EditionA connection string is a configuration string that specifies how a client connects to a database deployment, including its address and connection options.
-
Pro ASP.NET Core 7, Tenth EditionA connection string is a configuration value that specifies how software connects to a data source such as a database.
-
Building Distributed Applications that WorkA structured configuration value specifying how an application connects to a database.
Compare how 7 books explain connection string →
Related concepts
- appsettings.jsonconfigured by · appsettings.json is a conventional JSON configuration file used by .NET applications to store application settings.
- mongorestoreconfigures · mongorestore is a MongoDB Database Tools utility that restores data from BSON dump archives into a MongoDB database.
- IConfigurationused by · IConfiguration is the .NET abstraction for reading hierarchical application settings aggregated from configured key-value sources.
- mongoshused by · mongosh is MongoDB’s interactive command-line shell for connecting to deployments and executing database commands and queries.
This explainer was generated by Manning's knowledge graph from the text of .NET in Action, Second Edition. The section links point to the parts of the book it draws on.