Why should you care?

Real apps persist products and orders. EF Core is the standard data layer for .NET MVC.

See it live — copy this example

Create an MVC project (dotnet new mvc), add the code, and run dotnet run.

var products = await _context.Products
    .Where(p => p.IsActive)
    .OrderBy(p => p.Name)
    .ToListAsync();

Run Example »

This lesson uses terminal or setup steps. Run commands on your computer — the live editor appears on coding lessons.

What happened?

• Study the example line by line.
• Each part connects to Repository Pattern.
• Edit one line, save, and run dotnet run to see what changes.

Try it yourself

1. Check connection string in appsettings.json.
2. Run migrations if the lesson changes the schema.
3. Query data and confirm it appears in the view.
4. Change text or labels in the example and run again — watch the browser update.
5. Break the code on purpose (remove a semicolon), read the error message, then fix it.

Remember

You learned what Repository Pattern is and when to use it. Practice by changing the example yourself. Explain it in your own words before moving on.