Data Access in C# Fundamentals
Learn how to consume, persist and work with data stored in a database in any type of C# application. This course will teach you the different ways to work with data access in C# and what to keep in mind when applying this in your real-world applications.
What you'll learn
Creating applications that work with data from a database can be tricky, especially since there are multiple ways to do this. In this course, Data Access in C# Fundamentals, you’ll learn to consume, create, and properly work with data that you have in the database. First, you’ll explore the different ways of accessing data in C#, giving you an insight into different decisions you have to make depending on where you want to access data. Next, you’ll discover the most popular way of consuming data in C#, which is done through Entity Framework. This will then be compared against how you’d achieve the same thing, using ADO.NET, which Entity Framework is built on. Finally, you’ll learn about alternative data stores and introduce NoSQL. When you’re finished with this course, you’ll have the skills and knowledge of building applications that consume, and persist data in a database to build powerful, real-world applications.
Table of contents
- Introducing Entity Framework Core 12m
- The DbContext 4m
- Consuming Data 10m
- Query for Data with LINQ 6m
- Create, Update, and Delete Data 10m
- Inspecting the SQL 4m
- Using Entity Framework with a Different Data Store 9m
- Code First and Database First 2m
- Creating a New Database with Migrations 10m
- Summary 6m
- Introducing the Repository Pattern and a Data Access Layer 11m
- Creating a Generic Repository 12m
- Extending the Generic Repository 5m
- Consuming a Repository 9m
- Testing with a Fake Repository 8m
- Introducing Unit of Work 11m
- Applying Unit of Work 10m
- Introducing Lazy Loading 10m
- Value Holder, Virtual Proxies, and Ghost Objects 3m
- Summary 5m
About the author
Filip is an enthusiastic developer that strives to learn something new every day. With almost two decades of experience in .NET, Filip actively spreads his knowledge and ideas around the globe, be it speaking at conferences or online. Filip has worked in a range of different technologies such as WPF, Win Forms, ASP.NET, ASP.NET Core, Xamarin and .NET MAUI. In 2012, Filip published the book C# Smorgasbord, covering a vast variety of different technologies and patterns using C#, and right after Fi... more