How deeply does Building Web APIs with ASP.NET Core cover SQL script?

Explains generation, DBA review, and tool-based execution, while deferring detailed SQL commands and alternative implementation mechanics.

SQL script

As explained in Building Web APIs with ASP.NET Core

An SQL script is a file containing SQL statements that can be reviewed and executed to create or modify database structures or data.

An SQL script is a file containing SQL statements that can create or modify database structures or data. For the MyBGList production database, it provides a reviewable way to create the missing board-game tables. section 12.4.4

A deployment script offers practical advantages:

Generate it from the development machine with the dotnet-ef CLI, then execute it against the production database. section 12.4.4
Have an experienced DBA review and fine-tune the raw SQL for production requirements or to prevent accidental data loss. section 12.4.4
Use a dedicated SQL management tool, such as SSMS, because scripts are not self-contained executables. section 12.4.4

Generate the script

Run `dotnet ef migrations script -o ./Migrations/script.sql` on the development machine, review the resulting SQL, and execute it with a SQL management tool. section 12.4.4

> dotnet ef migrations script -o ./Migrations/script.sql

Inspect the concrete dotnet-ef command used to write a migration script to a file. section 12.4.4

How Building Web APIs with ASP.NET Core covers it

Cover of Building Web APIs with ASP.NET Core

liveBook manning.com

Read Building Web APIs with ASP.NET Core on liveBook Get the book at manning.com

Also explained in

liveBook manning.com

Rust Servers, Services, and AppsA SQL script is a stored sequence of SQL statements intended for execution against a database.

Compare how 2 books explain SQL script →

Related concepts

psql meta-commandused by · A psql meta-command is a backslash-prefixed instruction interpreted by the psql command-line client rather than by the SQL server.
migration bundle applicationalternative to · A migration bundle is a deployable executable containing Entity Framework Core migrations that applies those migrations to a database without requiring the .NET SDK or command-line tools.
databaseproduces · A database is an organized collection of persistent data managed by software for storage, retrieval, querying, and modification.
database tableproduces · A database table is a relational database structure that organizes records into rows and defined columns.
dotnet-efproduced by · dotnet-ef is the command-line tool for performing Entity Framework Core design-time tasks, including managing migrations and updating databases.
dacpacproduces · A DACPAC is a SQL Server data-tier application package containing definitions of database objects for schema deployment.

This explainer was generated by Manning's knowledge graph from the text of Building Web APIs with ASP.NET Core. The section links point to the parts of the book it draws on.