Pagination and Search

Goal

This snapshot advances Northline Press by teaching you to paginate the feed and search post text.

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

Prerequisites

Use .NET 8 SDK, a terminal, and Docker for Postgres stages. You should recognize C#, HTTP verbs, and basic HTML.

Port 5080 must be free. Copy .env.example and review appsettings.json before database stages.

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

Concepts

Pagination bounds work per page. Search filters with ILike before counting and slicing.

Keep page models thin: Razor Pages accept input, services and EF Core enforce rules, and Razor escapes output by default.

Walkthrough

Use page size 5, compute total pages, and accept a q query parameter.

Read the example, then open the matching snapshot. The repository includes the surrounding setup and error handling.

var pageSize = 5;
var pages = Math.Max(1, (int)Math.Ceiling(total / (double)pageSize));

Run and verify

Enter 10-Pagination-And-Search, restore packages, and run on port 5080.

Open http://127.0.0.1:5080. Watch the terminal for validation and database errors.

docker compose up -d
git clone https://github.com/michaeldunga1/fcc-aspnet-blog.git
cd fcc-aspnet-blog/10-Pagination-And-Search
cp .env.example .env
dotnet restore
dotnet run --urls http://127.0.0.1:5080

Troubleshooting

Off-by-one errors often come from mixing 0-based offsets with 1-based page numbers.

Restore errors usually mean the SDK is missing or you opened the wrong folder. For Postgres failures, confirm Docker is running and the northline_NN database name matches the snapshot.

• Read the first error first
• Restart after environment changes
• Never commit .env or production secrets

Try this

Search for ownership and confirm matching cards.

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