Stage 4 of 5

APIs and Databases

Add, view, edit, and delete tasks; these operations are called CRUD. Let another app request them through an API, and save tasks in a database using Entity Framework Core and SQLite.

Before you startBe able to run an ASP.NET Core app that receives a request and responds, and understand the request address and method.

GoalYou can define addresses to add, view, edit, and delete tasks, and save the data so it remains available after the app closes.

PracticeBuild a task API with CRUD endpoints backed by SQLite.

What to focus on in the course

You can define addresses to add, view, edit, and delete tasks, and save the data so it remains available after the app closes.

This page organises your learning and project; the course below supplies the detailed teaching. Use the task as your guide when choosing which lessons to study.

Teaching material for this stage

Choose a course, then apply it to your project

Focus on the topics needed for the stage task. Practise during the course; completing every video is not the readiness check.

Microsoft LearnFree

Build a web API with ASP.NET Core controllers

Resource language: Arabic
Level: Beginner to intermediate
Format: Interactive module in Arabic
Practice: Create, read, update, and delete (CRUD) exercises

Learners who want their first API using controllers and create, read, update, and delete operations.

Recommendation details

Microsoft LearnFree

Use a database with a Minimal API and Entity Framework Core

Resource language: Arabic
Level: Beginner to intermediate
Format: Interactive module in Arabic
Practice: Exercises using SQLite

Learners who want to connect a simple API to a database after learning HTTP and C#.

Recommendation details

Microsoft LearnFree

Entity Framework Core for beginners

Resource language: English video; Arabic resource page
Level: Intermediate
Format: Video series with an Arabic resource page
Practice: Practical examples

Learners who want a broader understanding of EF Core before expanding their data model.

Recommendation details

Build it yourself

Build a task API with CRUD endpoints backed by SQLite.

Start with the smallest working part. Test it, then add one requirement at a time. Keep your project for the next stage.

If you get stuck

Save your work and repeat the smallest step that shows the problem. Compare what you expected with what happened. Read the error message, check the last change, and use a resource above to revisit that idea.

Ready for the next step?

You can define addresses to add, view, edit, and delete tasks, and save the data so it remains available after the app closes. I can complete the stage task and explain the main parts without copying the whole solution. I have tested my project and can make a small change myself.

If a point is still difficult, practise it again before continuing.

Next: Project and Deployment