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

Ratings 3.67 / 5.00

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

What You Will 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

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!