Please ensure Javascript is enabled for purposes of website accessibility
Learn ASP.NET Core And SQL By Writing ToDo List API
4.0( 1 REVIEWS )
5h 27m

This course is designed for those interested to learn the basics of ASP.NET Core, how to use it with Dapper for back-end development, and how to build simple APIs.

Read more.
Course Skill Level
Beginner
Time Estimate
5h 27m

Instructor

An online courses community for people interested in creating a meaningful life through learning things you care about.

Access all courses in our library for only $9/month with All Access Pass

Get Started with All Access PassBuy Only This Course

About This Course

Last updated on July.2022

Who this course is for:

  • Students who are interested in building APIs
  • Students who are interested in learning more about ASP.NET Core
  • Students who are interested using Dapper with ASP.NET Core and ASP.NET Core Identity
  • Students who are interested in learning the back-end development with ASP.NET Core

What you’ll learn: 

  • Basics of back-end development with ASP.NET Core
  • Building a simple API, then taking the concepts and being able to use it for complex APIs
  • SQL Server and T-SQL, and how to create database objects for ASP.NET Core API
  • Using Dapper with ASP.NET Core API and ASP.NET Core Identity
  • Using ASP.NET Core Identity for registration and login process

Requirements: 

  • Basics of C# and T-SQL are preferable but not necessary
  • Windows machine that could handle Visual Studio 2019+ and SQL Server 2019+

Software version used in the course: 

  • Visual Studio 2019
  • SQL Server 2019

So the first question you will have is why even learn about ASP.NET Core? That is a very good question. The answer is that it allows you to build flexible and reliable APIs and web applications. In our course, we are going to laser focus on how to build APIs.

If one does not have a reliable API, then no matter how great the front-end, the user experience is going to be negative. This in turn will push a lot of people away from your product or the one you are building for a company.

The API is the gateway to your data so it needs to be secure, performant and reliable. ASP.NET Core has all of the tools to make this happen starting from handling simple requests to allowing users complete registration and login.

The main idea of this course is not to build a very complex API. Instead, I chose something pretty simple – ToDo list. Everybody knows how it works and there is no confusion there. This allows me to focus more on the mechanics of how ASP.NET Core works in order to build APIs.

We take it step-by-step and go over everything that we need to build and then we go ahead and build it. 

Now a word about Entity Framework. Just in case you are new to the Entity Framework – it is an ORM that helps you interact with the database. Helps you read, write, delete and more, so you don’t have to take care of it manually. The selling point of it is that it writes the “database code” automatically.

A very unique thing about this course is that we don’t use Entity Framework like every other course, but instead we are using Dapper. The reason is that using Entity Framework is pretty simple if there is no team. However, in the long term, it is known to have performance issues and it is not as flexible. Also when there is a team in place, it can become very tricky to navigate which migrations need to be run properly.

Dapper is made by the StackOverflow team and is widely used. However, Microsoft made it pretty difficult integrating with ASP.NET Core if one is not using Entity Framework. The goal of this course is to make the process simpler and show you exactly how to integrate Dapper with ASP.NET Core. We also write our own SQL which I show you is not as scary as it seems.

After we finish with the course, you will be able to make your own APIs with ASP.NET Core – all the way from handling simple requests to performing registration and login process.

Our Promise to You

By the end of this course, you will have learned how to use ASP.NET Core in back-end development.

10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.

Get started today and learn more about ASP.NET Core.

Course Curriculum

Section 1 - Introduction
Main Introduction 00:00:00
What Are We Building? 00:00:00
Section 2 - Setup
Install Visual Studio 2022 00:00:00
Install SQL Server 2019 00:00:00
Install SQL Server Management Studio 00:00:00
Section 3 - Outline All Pieces
Identify All Endpoints 00:00:00
Identify Database Actions 00:00:00
Section 4 - Build SQL Objects
Create Database And ApplicationUser 00:00:00
Create Category 00:00:00
Create UserToDo 00:00:00
Create Needed Types 00:00:00
Create Account_Insert 00:00:00
Creaet Account_GetByUsername 00:00:00
Create UserToDo_Delete 00:00:00
Create UserToDo_GetByUserId 00:00:00
Create UserToDo_Get 00:00:00
Create UserToDo_Upsert 00:00:00
Create Category_GetAll 00:00:00
Section 5 - Build Models
Create ApplicationUserLogin 00:00:00
Create ApplicationUserCreate 00:00:00
Create ApplicationUserIdentity 00:00:00
Create ApplicationUser 00:00:00
Create ApiException 00:00:00
Create UserToDoPaging 00:00:00
Create PagedResults 00:00:00
Create UserToDoCreate 00:00:00
Create UserToDo 00:00:00
Create Category 00:00:00
Section 6 - Build Repository
Create IAccountRepository 00:00:00
Create AccountRepository 00:00:00
Create IUserToDoRepository 00:00:00
Create UserToDoRepository 00:00:00
Create ICategoryRepository 00:00:00
Create CategoryRepository 00:00:00
Section 7 - Build Services
Create ITokenService 00:00:00
Create TokenService 00:00:00
Section 8 - Build Identity
Build UserStore 00:00:00
Section 9 - Build Web
Build AccountController 00:00:00
Build UserToDoController 00:00:00
Build CategoryController 00:00:00
Build ExceptionMiddlewareExtensions 00:00:00
Update Startup 00:00:00
Section 10 - Testing
Testing Account Controller 00:00:00
Testing UserToDo Controller 00:00:00
Testing Category Controller 00:00:00
Section 11 - Application Code
Download Application Code Here 00:00:00

Course Review

4.0

4.0
1 Ratings
  1. Anonymous

    Good Course

    4.0

    Good, but I would like to be a little more specific.

4764597

Join our newsletter and get your first course free!

4764598

Join our newsletter and get your first course free!

Congratulations! You get one free course of your choice. Please check your email now for the redemption code

Are you interested in higher education?