liveBook · Manning

Connection string

A connection string is a structured configuration value specifying how a client connects to a data source or service, including its location and connection parameters.

How 7 Manning books explain it

Building Web APIs with ASP.NET Core

A connection string is a configuration value that specifies how an application connects to a data source, often including server, database, and credentials.

How it is used
Connects the board-game API’s ApplicationDbContext to its SQL Server database.
How deep it goes
Shows credential setup, configuration storage, and DbContext registration, but does not dissect the connection-string options.
Examples
Uses a MyBGList SQL Server value named DefaultConnection and a Program.cs AddDbContext registration.
What you can do after
Apply it via EF Core to configure ApplicationDbContext for SQL Server and then create database structure with migrations.

Read how Building Web APIs with ASP.NET Core explains connection string →

Build Python Web Apps with Streamlit

A connection string is a structured value containing the address, port, credentials, and database name needed to connect to a data service.

How it is used
Configures the PostgreSQL connection used by a Streamlit CRUD app for persistent storage and retrieval.
How deep it goes
Defines the URL fields and works through local and hosted configuration, without detailing PostgreSQL connection internals.
Examples
Shows a local `secrets.toml` URL and a Neon Quick Start URL for a hosted database.
What you can do after
Operate/configure it by supplying the appropriate PostgreSQL URL for a local or Neon-hosted Streamlit SQL connection.

Read how Build Python Web Apps with Streamlit explains connection string →

Learn PowerShell Scripting in a Month of Lunches, Second Edition: Write and organize scripts and tools

A connection string is a formatted set of information that identifies a data source and specifies connection and authentication settings.

How it is used
Connects PowerShell automation to a selected SQL Server database with the required authentication settings.
How deep it goes
Explains server, database, authentication, SqlConnection assignment, opening, error detection, and closing without covering broader production administration.
Examples
Uses SQL Server Express strings for localhost, master, Scripting, Windows authentication, and explicit username-password authentication.
What you can do after
Operate/configure PowerShell database connections and reuse one connection string across module functions.

Read how Learn PowerShell Scripting in a Month of Lunches, Second Edition: Write and organize scripts and tools explains connection string →

MongoDB 8.0 in Action, Third Edition

A connection string is a configuration string that specifies how a client connects to a database deployment, including its address and connection options.

How it is used
Configures client access to a MongoDB deployment from mongosh, a Node.js application, or an SQL interface.
How deep it goes
Explains SRV server discovery and demonstrates connection commands, but does not detail the full URI option syntax.
Examples
Uses mongosh connection commands and a Node.js script that queries routes from JFK.
What you can do after
Apply it via mongosh or the Node.js driver to connect a client to an Atlas deployment.

Read how MongoDB 8.0 in Action, Third Edition explains connection string →

Pro ASP.NET Core 7, Tenth Edition

A connection string is a configuration value that specifies how software connects to a data source such as a database.

How it is used
Supplies database location and connection options for ASP.NET Core applications using Entity Framework Core or Identity.
How deep it goes
Defines JSON placement, single-line formatting, LocalDB values, and EF Core lookup, while deferring broader configuration-file behavior.
Examples
Uses LocalDB databases named SportsStore, Products, People, CalcDb, and Identity.
What you can do after
Configure a database connection by storing a named value in appsettings.json and passing its configuration key to AddDbContext.

Read how Pro ASP.NET Core 7, Tenth Edition explains connection string →

.NET in Action, Second Edition

A connection string is a configuration string that specifies how an application connects to a data source and its connection options.

How it is used
Selects SQLite's in-memory or file-based storage mode for an EF Core relational-database example.
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.

Read how .NET in Action, Second Edition explains connection string →

Building Distributed Applications that Work

A structured configuration value specifying how an application connects to a database.

How it is used
Connects Aspire services to existing databases or hosted resources through named configuration values.
How deep it goes
Shows registration, settings lookup, endpoint extraction, and resource-generated values; defers internally hosted database setup.
Examples
Uses an existing database, an Ollama model consumed by Semantic Kernel, and a MailDev SMTP resource.
What you can do after
Apply it via Aspire to supply an existing database connection or extract and validate an Ollama endpoint.

Read how Building Distributed Applications that Work explains connection string →

Related concepts

These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.