The DbSet represents the collection of all entities in the context. Every model must expose the DbSet property to become part of the Context and managed by it. We use the DbSet to query, insert, update & Delete entities. In this tutorial, we will look into DbSet and its methods in detail.
In this tutorial, we will show you how to install & use Mysql & MariaDB in Entity Framework Core. We will create a .NET Core console application. Install Entity Framework Core for MySQL & MariaDB. Create Simple Domain Models. Use Migrations to Create the database. Query, Insert, Update & Delete Rows.
In this tutorial, learn the various ways to install the Entity Framework Core. We can use the Entity Framework with both .NET Core & .NET Framework.
The Fluent API is one of the preferred ways to achieve the EntityType Configurations EF Core. In our previous tutorial on Fluent API in Entity Framework Core, We showed you how to configure an entity. We put all our configurations in the DbContext class. In this tutorial, we will show how to move the configurations to separate configuration classes using the IEntityTypeConfiguration Interface.
Entity Framework Core Cascade Delete is one of the Referential actions. These actions specify what to do with the related rows when we delete the parent row. We can configure these actions in the database and in the EF core (Client). The options available to use are Delete the related rows (Cascade / ClientCascade), Update its Foreign Key to NULL (SetNull / ClientSetNull) or do nothing (Restrict/ NoAction / ClientNoAction). We setup delete behavior between entities using the FluentAPI OnDelete method.
