ASP.NET Core complete course by University Coding Teacher C#

Declare a get item by title endpoint that reads the title from the query string and responds to an HTTP get request, illustrating parameter passing via the query string.

Learn how to set up an in-memory database with the Entity Framework Core, install the NuGet package, and map C# classes to the database model using an ORM.

Create a database context class inheriting from DbContext, configure it to use an in-memory database named books and authors, and register it in the service collection with AddDbContext in Program.cs.

Seed an in-memory database with sample books by injecting the database context into the books controller, adding three books when the table is empty, and exposing a get all endpoint.

Implement a delete item endpoint with the HTTP delete verb to remove a book by id from the books table, handling not found cases and saving changes.

Duplicate the books controller to create an authors controller, rename properties to first name and last name, adjust endpoints like get author by last name, and test get all.

Install SQL Server Express Edition, download, install, and set up SQL Server Management Studio to connect to the local database engine; for macOS or Linux, run SQL Server in Docker.

install two entity framework nuget packages, sql server and design, then switch to sql server by adding a dbcontext constructor with options and using the books and authors connection string.

configure a real sql server database for an ASP.NET Core app, define db sets, and apply entity framework migrations to create authors and books tables.

Build a one-to-many relation between books and authors using a foreign key author_id and navigation properties. Apply a migration to update the database and verify the new foreign key.

Seed a database with initial data using on model creating and has data method, enabling conditional seeding for authors and books with migrations and a database update.

Map create update book and author DTOs to entities, update controllers to return new IDs, and validate automapper mappings for adding and updating items in the API.

Explore validation attributes in ASP.NET Core, including required, string length, range, email, phone, url, and regular expressions, and apply them to book and author dtos with endpoint checks.

Explore how launch settings define http, https, and IIS Express profiles to run an ASP.NET Core app on Kestrel or IIS Express, with automatic browser launch to Swagger.