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

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!