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 CompTIA Security+ Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Mindfulness Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift 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
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Freelancing Online Business 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
Development Software Engineering Data Access

C# data access: from ADO.NET to EF and Dapper

Learn basics of SQL Access with ADO.NET, Dapper, Entity Framework. NoSQL with Mongo and Redis. Also: DAL patterns
Rating: 3.6 out of 53.6 (28 ratings)
223 students
Created by Timo H. | C# Development | .Net | DevOps
Last updated 9/2019
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • SQL Database access with Ado Net
  • SQL Database access with Entitiy Framework
  • SQL Database access with Dapper
  • MongoDb access with MongoDb .Net Driver
  • Redis access with ServiceStack Redis

Course content

8 sections • 52 lectures • 3h 5m total length

  • Preview05:57
  • Preview05:00
  • Basics of Data Acess: CRUD operations
    01:29
  • How to work with the Github Repository to answer questions
    04:31

  • What this section covers
    03:11
  • Preview02:38
  • Simple SELECT with PostgreSQL
    02:57
  • SqlDataReader for SELECT and JOIN
    02:49
  • Utilize SQL Parameters
    03:20
  • INSERT with ADO.NET
    02:12
  • UPDATE and DELETE with ADO.NET
    02:18
  • SQlDataAdapter for SELECT
    03:25
  • Transactions with ADO.NET
    05:53
  • Summary
    01:50
  • SQL With ADO.Net
    4 questions
  • Extract Data from the Sqlite Database
    5 questions

  • Introduction to Entity Framework
    06:57
  • Connect to the databases with Entity Framework core
    04:29
  • Select and Join with Entity Framework
    03:04
  • Insert, Update and Delete with Entity Framework
    05:02
  • RawSql with Entity Framework
    01:01
  • Another ORM: Dapper
    03:27
  • Preview03:04
  • Inner Join with Dapper (One to Many Relationship)
    03:27
  • Insert, Update and Delete with Dapper
    04:49
  • Summary ORMs and further Resources
    05:19

  • Deeper look into Dapper
    03:25
  • Query versions: First, Single, Easier Join and QueryMultiple
    03:46
  • Dapper Commands: Use Lists as Parameters
    02:07
  • Dapper Use DynamicParameters to control Input and Output parameters
    03:03

  • Intro to NoSQL database types
    05:48
  • Short intro to MongoDb and MongoDb Driver for .Net
    02:14
  • Preview02:41
  • Read and InsertMany with MongoDb
    04:01
  • Update and Read with MongoDb
    02:06
  • Delete all Documents and the entire Collection with MongoDb
    02:13

  • Short intro to Redis NoSQL database
    02:12
  • Setting up Redis in docker for CRUD operations
    03:31
  • Redis Connect, Create and Read
    03:30
  • Redis: Update and Delete
    03:07
  • Summary: Accessing NoSQL databases
    03:05

  • Introduction and basic idea
    04:35
  • Query object pattern explained
    02:23
  • Query object pattern implemented as Dapper and EF Access Query
    04:55
  • Repository pattern idea
    06:43
  • Implement most simple Repository
    05:52
  • EF as repository and why you still can use a Repository on top
    06:53

  • Setup the SQLite database for this course
    04:00
  • Preview02:57
  • All the used SQL Statements for this course
    03:22
  • Add Nuget packages for the ADO.NET providers
    01:41
  • Setup MongoDb NoSQL for the course
    03:17
  • .Net basics of IO: Streams
    02:09
  • Serialization and Deserialization
    02:12

Requirements

  • Basic Knowledge in any .Net Language is required to understand the examples, C# would be the most easiest
  • The desire to learn the fundamentals of Data Access to go from there
  • Some SQL or NoSQL knowledge might help, yet is not a must

Description

One of the most important aspects of working effectively with any application is accessing and storing the persistent data.
There is no application without data, be it SQL, NoSQL or any other form of a persistent data store.
For all of them the fundamental concepts are similar.

In this course we are going to explore the CRUD operations for different styles and with different technologies.

You will get an insight into all of the following data access technologies and how they are structured:

  • SQL Databases with Sqlite and PostgreSQL

    • ADO.NET

    • Entity Framework

    • Dapper

  • NoSQL

    • MongoDb withMongoDb Driver

    • Redis StackExchangeRedis

  • Also:

    • Refresh basic Knowledge on SQL

    • Setup postgres and redis in docker containers

    • learn how to store data in MongoDb works essentially

    • SQL vs NoSQL, when is which appropriate?


    Enrolling in this course will boost your productivity and the understanding of how to access any data storage you might encounter. In the end it is all about the information you can store and retrieve.


    You should be familiar with .NET in general and C# in particular. You need not to be an expert, but you should be somewhat comfortable with reading code written in dotnet core.

    Now have fun and enjoy the course!

Who this course is for:

  • .Net Developers
  • C# Developers in particular
  • Professional developers in the Microsoft stack in general

Instructor

Timo H. | C# Development | .Net | DevOps
Freelancer & .Net Developer
Timo H. | C# Development | .Net | DevOps
  • 3.9 Instructor Rating
  • 615 Reviews
  • 7,811 Students
  • 12 Courses

I am a passionate software developer in the world of .Net programming.


As a Freelancer I support my clients with custom made solutions, consultancy or on site and online trainings in a wide range of topics.

Besides programming in .Net I also work with Python, SQL/NoSQL databases and the usual DevOps capabilities like docker and public cloud systems (Azure and AWS)

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