Development
Software Engineering
Data Access
C# data access: from ADO.NET to EF and Dapper
3.7 (25 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
191 students enrolled

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
3.7 (25 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
191 students enrolled
Created by Timo H. | C# Development | .Net | DevOps
Last updated 9/2019
English
English [Auto]
Preview this course
C# data access: from ADO.NET to EF and Dapper
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
Buy now
30-Day Money-Back Guarantee
This course includes
  • 3 hours on-demand video
  • 3 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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
Expand all 52 lectures 03:05:57
+ – Introduction
4 lectures 16:57
What is this course about?
Preview 05:57
SQL vs NoSQL
Preview 05:00
Basics of Data Acess: CRUD operations
01:29
How to work with the Github Repository to answer questions
04:31
+ – SQL with ADO.NET
10 lectures 30:33
What this section covers
03:11
First SELECT query with ADO.NET: SQLite
Preview 02: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

Questions to deepen your knowledge on SQL Access with ADO.NET

SQL With ADO.Net
4 questions
Setup the Sqlite database and try to use the access code to extract specific data.
Extract Data from the Sqlite Database
5 questions
+ – SQL with ORMS: Entity Framework and Dapper
10 lectures 40:39

Learn about EF core. If you come this far, and want to learn all there is about EF core, then simply send me a  DM stating your interest in EF Core and I will make sure that you get a coupon to my EF core course for free.

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
Select with Dapper
Preview 03: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
+ – More on Dapper: Query versions and Commands
4 lectures 12:21
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
+ – Access MongoDb NoSQL with .Net
6 lectures 19:03
Intro to NoSQL database types
05:48
Short intro to MongoDb and MongoDb Driver for .Net
02:14
Connect to MongoDb
Preview 02: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
+ – Access Redis NoSQL with .Net
5 lectures 15:25
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
+ – Data Access Layer Abstractions: Query independent of database type
6 lectures 31:21
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
+ – Bonus: Setup and Basics
7 lectures 19:38
Setup the SQLite database for this course
04:00
Setup postgres for this course (in a docker container)
Preview 02: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!

UPDATE:
This course now comes with a free coupon to my EF core Course. To get this, just message me via a DM with 'Entity Framework Core' as the content.

Who this course is for:
  • .Net Developers
  • C# Developers in particular
  • Professional developers in the Microsoft stack in general