Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS AWS Certified Developer - Associate CompTIA Security+
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 3 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
Development Web Development ASP.NET Core

Dapper - Getting Started

Gain practical knowledge of Dapper as we integrate with ASP.NET Core (.NET 5) application and learn advance concepts.
Rating: 4.6 out of 54.6 (45 ratings)
211 students
Created by DotNet Mastery, Bhrugen Patel
Last updated 8/2020
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • 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!

Course content

7 sections • 46 lectures • 3h 3m total length

  • Preview01:28
  • Preview01:11
  • Preview05:32
  • Preview00:56
  • Preview01:54
  • Tools Needed
    01:54
  • Create Project
    02:22

  • Preview03:33
  • Preview04: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

  • 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 Repository
    05:07
  • Employee Controller
    04:18
  • UI Changes
    03:51
  • Employee CRUD
    06:06
  • Display company Id
    01:34

  • 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 Setup and Model Change
    04:25
  • Dapper Contrib Get and GetAll
    03:59
  • Dapper Contrib Insert, Update and Delete
    02:38

  • 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

Requirements

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

Description

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.

Who this course is for:

  • Anyone who wants to learn fundamentals with advance concepts in Dapper

Instructors

DotNet Mastery
Ultimate Training Resource for .NET Developers
DotNet Mastery
  • 4.7 Instructor Rating
  • 377 Reviews
  • 1,620 Students
  • 6 Courses

DotNetMastery's mission is to provide the most comprehensive training for .NET Developers.

We want to make coding and software engineering accessible to everyone through courses that are simple to follow, but still give exposure to solve real world challenges. All the courses have real world exposure to make sure, not just to teach you technology but make you ready for real world challenges.

Most important part about writing and teaching code is to eliminate the hardships of every student out there who is willing to learn but cannot find adequate resource which is easy to understand.

DotNetMastery's goal is to provide quality and real world training in the .NET world.

Coding is a way to be creative and have fun!

Bhrugen Patel
Passionate Software Developer
Bhrugen Patel
  • 4.5 Instructor Rating
  • 11,992 Reviews
  • 76,114 Students
  • 20 Courses

I am a passionate and creative software engineer with a strong focus on simplicity and thorough details. I have been programming since high school and I have been involved with multiple web and desktop using .net.

I have a master's of science degree in computer science and a Bachelor of Computer Engineering. I also have many years of experience with .NET C# and .NET MVC. I enjoy teaching along with my full-time job.

For me, the most important part about writing and teaching code is to eliminate the hardships of every student out there who is willing to learn but cannot find adequate resource which is easy to understand. Coding is a way to be creative and have fun! 

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.