Data Layer

Goal

This snapshot advances Rivergate Market by teaching you to model categories and products with migrations and seeds.

Every numbered folder is a complete app. Run this stage independently, then compare it with the previous folder.

Prerequisites

Use .NET 8 SDK and Docker for Postgres stages.

Port 5082 must be free. Copy .env.example before database stages.

• .NET 8 SDK
• A code editor and terminal
• Docker from part 4 onward

Concepts

Each snapshot uses an isolated river_NN database so stages stay independent.

Razor Pages keep handlers close to markup; cookie auth owns the session; EF Core persists catalog and orders.

Walkthrough

Migrate Category and Product tables, relate them, and seed Ada, Grace, and a starter catalog.

Read the example, then open the matching snapshot. The repository includes validation, CSRF, and the surrounding structure.

public class Product {
  public int UserId { get; set; }
  public string Slug { get; set; } = "";
  public int PriceCents { get; set; }
}

Run and verify

Enter 04-Data-Layer, copy .env.example, restore, migrate, and dotnet run on port 5082.

Open http://127.0.0.1:5082. From data lessons onward, Ada and Grace use password123.

docker compose up -d
git clone https://github.com/michaeldunga1/fcc-aspnet-ecommerce.git
cd fcc-aspnet-ecommerce/04-Data-Layer
cp .env.example .env
dotnet restore
dotnet ef database update
dotnet run --urls http://0.0.0.0:5082

Troubleshooting

Connection refused usually means Docker is down or the database name does not match this folder's index.

For database failures, confirm Docker and the river_NN name. Never commit .env, bin/, obj/, or secrets.

• Read the first exception first
• Rebuild assets after Tailwind class changes
• Never commit secrets

Try this

Add a nullable sku column through a new migration.

Test a happy path and one invalid or unauthorized request.

• Make one small change
• Test it in the browser
• Compare with the next snapshot only after it works