.NET Core MVC with Dapper - The Complete Course Full Scratch

Name: .NET Core MVC with Dapper - The Complete Course Full Scratch
Rating: 4.4 (12 reviews)

Ecommerce Project using Dapper Micro ORM with Stored Procedure

Created byTarun Kumar Saini

Last updated 8/2024

English

What you'll learn

Dapper Fundamentals Tutorials , How Dapper Communicate with database objects. How Dapper Handle Relationships like one to one and one to many and many to many
Complete Example of Ecommerce Project in .NET 8 with Dapper Technique. In project we have Some modules like UI, Product catalogue , cart and Order Details
How Dapper Handle Authentication and Authorization using efficient manner. Dapper communicate with database table create a session. Use Filters to Authorize
In this project we have a Repository pattern with Dependency Injection to handle Dapper Communication. We have a Dashboard for Admin and Customer. Admin Manage
Product Catalogue. Right now payment option is under processing but we will add later using stripe method and razor pay
Dapper Communicate with database table using stored procedure.

Course content

11 sections • 65 lectures • 6h 59m total length

Ecommerce Project Demo using Dapper5:07
Getting Started with Ecommerce Project using Dapper18:56
Set up ecommerce project with dapper by creating database, category and product tables, wiring a dapper context, and exposing a json api to fetch products with categories using stored procedure.

Add and Update Product Service9:30
Continue with Product Controller9:10
Delete Product4:23
Fetch the product by id, delete its image via the utility service, then execute the stored procedure to delete the product by id, and redirect to the index.
View for Get All Products11:04
Design a view for the all products page in a .NET Core MVC app, using a data table with create and update actions and toaster and sweet alert notifications.
View for Create Update Action method20:21

User Role and Their Relationship Query for Create Table3:18
Stored Procedure for Add Role and Add User4:01
Data Seeder Class12:58
Register Data Seeder in Program file4:11
ViewModels for Accounts2:33
Register and login Service8:33
Build a register and login service in .NET Core MVC with Dapper, including an application user model, authenticate and register async methods, and an accounts controller for auth flows.
Register and Login Action Method10:09
Login Partial Page7:29
Register your Authentication Handlers6:12
Get User Roles7:18
Authorization Filter8:19
Implement a role based authorization filter by creating a role authorize attribute that implements IAuthorizationFilter and checks user roles, routing unauthenticated users to login and denying access when needed.
Get UserId Service3:35

Cart Controller Part-19:11
Show Cart Items6:09
View Components8:59
Session Configuration1:43
Show Cart Icons with Quantity3:20
Stored Procedure for Increment and Decrement Quantity2:21
Service for Increment and Decrement Quantity4:41
Update cart Quantity6:08
Implement cart management by adding plus, minus, and delete actions to update item quantities via the card service and refresh the session cart after changes.
Signout Functions4:43
Delete cart Item By ID5:36
Delete a cart item by id using a stored procedure, wire up the service, controller, and views to remove the item and refresh the session cart, then proceed to payment.

Cart Summary Page4:08
User Profiles Table Script and Stored Procedure3:37
Services for User Profile4:28
Create User Profile16:49
Create or Update User Profile2:11
Cart Summary7:09
Build a cart summary by loading user info through the user profile service, aggregating cart items into an order header, and calculating the total for display.
Payment Status and OrderStatus4:41
OrderHeader and OrderDetails Table3:19
Stored Procedure for OrderHeader and Order Details Table3:34
Services for Order header and Order details table5:04
Generate a Order8:49

Requirements

Student must have basic Programming skills about C# and ASP .NET Web Frameworks

Description

Dapper Fundamentals Tutorials , How Dapper Communicate with database objects. How Dapper Handle Relationships like one to one and one to many and many to many. Complete Example of Ecommerce Project in .NET 8 with Dapper Technique. In project we have Some modules like UI, Product catalogue , cart and Order Details. How Dapper Handle Authentication and Authorization using efficient manner. Dapper communicate with database table create a session. Use Filters to Authorize. In this project we have a Repository pattern with Dependency Injection to handle Dapper Communication. We have a Dashboard for Admin and Customer. Admin Manage. Product Catalogue. Right now payment option is under processing but we will add later using stripe method and razor pay. Dapper Communicate with database table using stored procedure.

- Modules of the Ecommerce Project

Admin Module - CRUD Operation on Product and Category Catalogue , Manage Customer Order

Customer Module - Add Item into Cart and Proceed Order

Dapper Connection - Using one to many and many to many mapping

Dapper Security - Custom User Account with Hased password

Seed User Information using Dapper

Repository Pattern with Dependency Injection.

Dapper Methods which is Used in Project- ExecuteAsync, QueryAsync,QueryFirstOrDefault, Split Tables

Access data from database table via stored procedue.

Filters - Customer Request filter by their roles. In this project , i use custom Authorize Filter for customer request

Who this course is for:

Beginners Who want to Learn Dapper with ASP. NET

.NET Core MVC with Dapper - The Complete Course Full Scratch

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 24min

Controller, Services and Stored Procedures6 lectures • 36min

Utility Service2 lectures • 13min

Continue with Product Controller5 lectures • 54min

Home Page Design1 lecture • 4min

User Management12 lectures • 1hr 19min

Continue with Controllers6 lectures • 36min

Cart Controller10 lectures • 53min

Cart Summary11 lectures • 1hr 4min

Theme Setup3 lectures • 18min

Requirements

Description

Who this course is for: