Course Information
Course Overview
A Complete Web API using ASP.NET, Entity Framework and SQL Server | REST API for E-Commerce Applications
This course is for Beginners to ASP.NET having some knowledge of C# or similar programming languages.
In this course, you will learn how to build a complete Web API using ASP.NET. I will show you how to build a secure and professional backend application for E-Commerce.
We will use Visual Studio 2022 to connect to the SQL Server. So we don’t need to install SSMS (SQL Server Management Studio).
In this course, you will learn:
- How to create an ASP.NET Web API
- How to connect to SQL Server using Visual Studio 2022
- How to create API Controllers
- How to Create Endpoints and action methods
- How to create and use Middlewares
- How to create and use Filters
- How to validate forms using attributes and how to add custom validation
- How to send emails using ASP.NET and SendGrid
- How to Implement Authentication, Authorization and Role based Authorization using Json Web Tokens (JWT)
- How to reset user password
- How to perform CRUD operations (Create, Read, Update and Delete) on the database using Entity Framework and other frameworks
- How to implement pagination, search and sort functionalities
- How to upload images to the server
To follow this course, you need to install the following tools
- Visual Studio 2022
- Microsoft SQL Server
Course Content
- 9 section(s)
- 115 lecture(s)
- Section 1 Introduction
- Section 2 ASP.NET Web API Essentials
- Section 3 Entity Framework
- Section 4 CRUD Operations on Contacts
- Section 5 CRUD Operations on Products
- Section 6 Authentication and Authorization
- Section 7 Shopping Cart and Orders
- Section 8 Authentication and Authorization using Identity API (.NET 9)
- Section 9 Entity Framework Alternatives
What You’ll Learn
- Build a Complete Web API using ASP .NET and C# for E-Commerce Applications
- Understand the Architecture of ASP. NET Web API applications
- Understand Domain Models and Data Transfert Object (DTO) Models
- Use Built-in Data Validation (with Attributes) and Custom Validation
- Understand Dependency Injection: Add Services to the Service Container and Request Services within the Controllers
- Read and Write Data in SQL Server Database using Entity Framework and Other Frameworks
- Understand How to Add and Use Entity Framework - Create Database Tables and Perform CRUD Operations
- Perform CRUD Operations Using Entity Framework and SQL Server Database
- Add Pagination - Search - Sort Functionalities
- Implement Authentication and Authorization Using Json Web Tokens (JWT)
- Implement Role-based Authorization Using JWT
- Create User Accounts
- Reset User Passwords
- Upload Images
- Send Emails
- Build Shopping Cart Summary from product string
- Create and Manage Orders
- CRUD Operations Using Dapper
Skills covered in this course
Reviews
-
UUrja
yes it is a good course
-
DDavid Mwaifunga
The course is a good refresher and quick straight to the point. I think this is great delivery, though at times i need to go and do some extra research on some points. The fact that time is not wasted and every second is valuable makes it a big plus. Great job putting this together
-
DDan B
This is an excellent course. If you have some knowledge of C# and the very basics of ASP.NET, then this is a great way to see multiple models, controllers and services being set up and how they interact. Would highly recommend. I've also seen a couple of reviews saying some of the code doesn't work - it works absolutely fine, I would suggest that is likely student error.
-
AArumugam
Very nice course