C# data access: from ADO.NET to EF and Dapper
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
- 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
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
MongoDb withMongoDb Driver
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
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/C# I also work with Python, SQL/NoSQL databases and the usual DevOps capabilities like docker and public cloud systems (Azure and AWS)