Real rest Web API using C#, SQL, Dapper, Json.

Name: Real rest Web API using C#, SQL, Dapper, Json.
Rating: 3.9 (15 reviews)

Creating a real e-commerce Web API.

Created byAdam Eldeek

Last updated 9/2020

English

What you'll learn

Build a database and stored procedures in Sql management studio.
Build a full Web API application with .net core using Dapper , Json & C#.
Build an example to sell used products.
This application will contain all actions you need like register a user, reset the password, verify your email, control you selling etc.
After this course you will be able to build a real Web API application.

Course content

11 sections • 47 lectures • 3h 21m total length

Welcome to my course.2:07

Creating the database and tables in SQL Server Management Studio - Part 1.2:35
Create a new database in SQL Server Management Studio, switch to it, and define a users table with id as an identity column, plus username, email, password, and email confirmed.
Creating the database and tables in SQL Server Management Studio - Part 2.5:47
Creating the database and tables in SQL Server Management Studio - Part 3.4:06

Add AccountsController to the Project.2:38
The lecture shows how to add an accounts controller to the project, create an empty api controller, and configure a private field and connection string from configuration.
RegisterUser stored procedure in SQL Server.9:20
RegisterUser models.2:13
Create register user model and register user result model in Visual Studio project, defining username, email, and password, then include user id, username, and email in the result.
RegisterUser action.8:21
RegisterUser Test.2:44
Hash password5:16
hexadecimal is a positional system that represents numbers using a base of 16. it uses sixteen distinct symbols, most often the symbols "0"–"9" to represent values zero to nine, and "A"–"F" (or alternatively "a"–"f") to represent values ten to fifteen.

Don't forget to verify some user's email and to save some user's passwords before hashing them to test sign-in action method.
Hashing the Password -Test our code1:49

Requirements

Basic knowledge in SQL, C#.
Basic Knowledge in Rest API concept.

Description

Course Tools

SQL Server Management Studio.

Visual Studio.

Postman.

Advantages of this course :

- Learning in real app, where we design an API that meets business objectives.

Such way is considered to be a highly important learning process. Besides, it equips you with a knowledge that can be easily extended and integrated.

- Building Database first, this approach give the developer a lot of advantages like protect you from losing data, and easier to write SQL commands.

- Using C#, which is an object-oriented, component-oriented programming language that supported by Microsoft, and the best news that it will be immediately familiar to C, C++, Java, and JavaScript programmers.

And the most famous advantage of knowing C# is the expanded wideness to make mobile applications, web applications, games and more.

- Using Asp.Net Core, a free and open-source web framework developed by Microsoft. This framework allows us to include packages in our application which make it faster.

- Using Dapper, that is a tool which maps your database directly with C# objects. Fast in performance with fewer line of code.

- Using Json syntax, which is fast and readable way to exchange data between the server and our application, it’s actually a text that written with JavaScript object notation..

Who this course is for:

For student who wants to build a real ASP. NET CORE Web API in a simple, quick and professional way.
For students who know that dapper is more faster than entity framework.
For students who know that learning in workshops and full featured examples is more efficient than using a small examples for every single concept.

Real rest Web API using C#, SQL, Dapper, Json.

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 2min

Creating the database3 lectures • 12min

Setup the project in Visual Studio3 lectures • 5min

Register a new User7 lectures • 32min

Send email to user to verify the registered account.4 lectures • 28min

Sign In3 lectures • 12min

Reset the password and get a new verification code.3 lectures • 13min

Add, Update and get user's contact details.5 lectures • 22min

Fix some issues inside our application.2 lectures • 17min

Add and Update user's address2 lectures • 10min

Requirements

Description

Who this course is for: