Mô tả

Dapper provides a super fast library for mapping between databases and .NET. This code-focused course will introduce you to all the basics you need to be productive with Dapper and how to incorporate Dapper in your project.

This is an introductory course on Dapper with ASP.NET Core (.NET 5). This course is for anyone who is new to Dapper for overview with exposure to some advance concepts of Dapper.

When you are finished with this course, you will have the skills and knowledge of Dapper needed to build elegant and high-performance data access layers.

Bạn sẽ học được gì

Basics of Dapper

Perform CRUD operations with Entity Framework Core.

Perform CRUD operations with Dapper using SQL.

Perform CRUD operations with Dapper using stored procedures.

Complex parent-child objects in Dapper

Dapper Contrib library.

Advance Dapper concepts like relations in mapping, N+1 query, repository and much more!

Yêu cầu

  • Visual Studio 2019
  • SQL Server Management Studio
  • .NET 5 (or .NET Core)

Nội dung khoá học

7 sections

Introduction

8 lectures
Introduction
01:28
Course Overview
01:11
ORM vs Micro ORM
05:32
Udemy Review
00:20
Naming Conventions
00:56
Project Resources & Github
01:54
Tools Needed
01:54
Create Project
02:22

Entity Framework Core

7 lectures
Create Company Model
03:33
Create DbContext
04:14
Configure Startup Class File
02:37
Create Database and Tables
02:48
Scaffold EF CRUD
04:43
Implement Entity Framework Repository
06:08
Entity Framework Repository Demo
04:14

Dapper Hands On

7 lectures
Configuring Dapper Repository Part 1
03:25
Get All - Dapper
02:03
Dapper - Get Single
02:29
Dapper - Create
05:18
Dapper - Update
03:06
Dapper - Delete
01:20
Add Employee Model
04:24

Employee Dapper

5 lectures
Employee Repository
05:07
Employee Controller
04:18
UI Changes
03:51
Employee CRUD
06:06
Display company Id
01:34

Stored Procedures in Dapper

4 lectures
Add Stored Procedures
04:44
Get Stored Procedure
03:55
Dynamic Parameters with Dapper
05:19
Stored Procedure Update and Remove
03:11

Dapper Contrib

3 lectures
Dapper Contrib Setup and Model Change
04:25
Dapper Contrib Get and GetAll
03:59
Dapper Contrib Insert, Update and Delete
02:38

Advanced Dapper

13 lectures
Setup Bonus Repository
01:29
N + 1
03:08
One to One Relation in Dapper
10:33
One to One Relation with Parameters
04:38
Multiple Result Sets in Dapper
08:28
One to Many Relation in Dapper
05:38
Display all company and employees
04:39
Insert Company With Employees Populated
05:34
In Clause and Remove Range in Dapper
07:08
Bulk Insert in Dapper
02:18
Transaction in Dapper
05:15
Async Version
03:11
Generic Dapper Stored Proc Repository
06:33

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.