Entity Framework core: SQL Data Access with C# & .Net

Learn about the application we are going to build and why we focus here on its entities alone.

In this video we lay the groundwork for this chapter with the git branches in use and the required nuget packages for the chapter

In this video we set up the Sqlite Database inside the data directory of our application for the further use of the db-first approach.

In this video we are going to create a Docker container with a postgres database instance. Inside of it we use the sql script from the chapter2.code (see introduction resources) to restore a postgres database. This we will then use in the course from now on.

Learn in this video about the db first commands for sqlite and postgres to generate the  POCOs and the DbContext.

In this video you will learn how we can setup our data entities for the entity framework core code first approach. This is the first part, where the POCOs are created and explained why they have to be setup this way.

Learn how we define relationships and map Entity Properties to the database tables using the fluent API of EF Core in this video.

This video explains how to translate our POCOs and the dbcontext to a Migration and from there to a ready created Database with our schema.

This video describes how Conventions in EF Core can be used to map Entities to Database Table constructs. It also describes what attributes are, and how they relate to the definitions we already did with the fluent API

In this course we again take a look at everything we did in this chapter from setting up the providers to the Db first and code first  approaches.

In this introductory video to this chapter we talk about what we are about to learn in this chapter. We start out with revisiting the DbContext and LINQ.

In this video we prepare the infrastructure for this courses application. That is we create some command line parsing and add some UseCases that can be invoked later.

In this video we will learn to insert single data and collections of data with EntityFramework Core by using the Query API in our just created use cases.

In this video we are going to look at very simple queries and how they translate to SQL statements. For this we use our created/seeded data from the last video.

This video explains how to use eager loading to join entities and therefore fill up the navigationproperties we built so far.

In this video we take a look at how you can speed up readonly queries with ef core by utilizing a method known AsNoTracking.

In this video we learn how and where LINQ Queries assembled on our DbContext and DbSets are evaluated and how you should usually go about it.

This video shows how to test for entities in a table with the Any Operator. We do this by inserting data into the join tables of our data structure. We then also learn how to utilize Skip and Take, which is commonly used for paging in applications.

In this video we tackle the last outstanding operations of the CRUD acronym, that is Update and Delete, with entityframework core.

This video concludes the chapter as it summarizes the key points made during this chapter.

This video shows what will be done in this chapter with regards to migrations. We also take a look again at what Migrations offer us and why we should use them.

Learn how you can add a Property to an entity and translate this change to the database using a migration.

In this video we will again create a Migration for the added stations property. But this time around we use the postgres database provider and a slightly different approach to fix our (intended) mistake.

When we created migrations we have different ways to apply them to the database. There are exactly 3 of them and we will discover which ones are those in this video.

In this video we will learn how the two alternative ways to apply a migration to the database can be executed. Namely using code to migrate and using a generated sql script to do so.

In this video we add a relationship of the Products and the Station Entity and apply the resulting Migration to the database.

This video shows, what shadow properties are, what they are good for and why we have them as a feature in ef core.

Understand how shadowproperties are created, and if need be how you can read them from the database, even though they are not part of your entity model.

In this video we summarize all the topics we covered in this video.

Learn in this short intro what we are going to cover in this chapter.

This video shows the first report which yields anonymous objects that contain information about the products and is then sorted for costs and throughput time

In this report we take the query api a step further and try different not yet used LINQ operators

Follow this instructions to tinker with your own reporting.

Learn in this video, what we are going to cover in this chapter.

In this video we introduce the changetracking feature and how it works in general.

In this video we create two UseCases, to see how the Changetracking states are assigned to our entities in different scenarios. We will also learn how we can change those states manually.

The ChangeTracking Feature offers two Events we can attach a Handler to, so we can react to them in a proper fashion. Learn in this video how this can be accomplished.

In this video we look at the things we will cover with regards to some edge cases in the use of ef core. On the one hand this covers sending your own custom written SQL to the database and on the other hand it is concerned with the Query Types we use to avoid any new Mappings or Primary Keys.

Learn in this video how rawsql can be used to query Products with a Select * Statement.

Learn how we can handle Views or other SQL Entities without a primary key by utilizing query types.

In this Video we will learn how the mapping with the underlying technology works and how we can enable logging with EF Core.

Learn how Inheritance of Objects is handled with SQL Database Table structures and Realtionships. Also we will find out which approach is supported in EF core.

Learn in this video how you can implement inheritance with ef core by using table per hierarchy.

This video summarizes what we covered in this chapter.

In this video you will learn about SQL Tables and Datatypes and how they relate to objects. We will also see how we usually interact with a SQL database by use of the three different conceptual language types for SQL.