← All projects

Pagination and Search

Paginate the feed and search post text.

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

Related tutorials