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
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!
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
Who Should Attend!
- .Net Developers
- C# Developers in particular
- Professional developers in the Microsoft stack in general