Why should you care?

ShopNest.DataAccess demos fail until the engine and a ShopNestDb database exist.

See it live — copy this example

Use a .NET console or API project with SQL Server LocalDB. Run dotnet run after pasting.

-- SSMS / sqlcmd
IF DB_ID(N'ShopNestDb') IS NULL CREATE DATABASE ShopNestDb;
USE ShopNestDb;
CREATE TABLE Orders (
  Id INT IDENTITY PRIMARY KEY,
  CustomerId INT NOT NULL,
  Total DECIMAL(18,2) NOT NULL,
  Status NVARCHAR(20) NOT NULL
);

What happened?

• Create ShopNestDb and a minimal Orders table.
• Same schema used across early lessons.

Practice next

1. Install LocalDB or Docker SQL.
2. Run the script in SSMS.
3. Note server name for connection strings.
4. Add OrderDate DATETIME2.
5. Create a Payments table stub.

Remember

Engine + database first. Tiny schema for practice. Reuse ShopNestDb.

ShopNestDb bootstrap

Devs share one schema script.

Outcome: Everyone’s samples run against the same tables.