Yesterday, the friends in the '.NET Big Cow Road' group discussed the topic of implementing the repository pattern using EF Core. I remembered an article written by a foreign expert that I had read before, and I think it's very valuable for reference.
When using EF Core, many times you need to know what SQL statements EF Core actually executes.
Several suggestions
The framework `Zack.EFCore.Batch` for `batch` performing `update`, `delete`, and `insert` operations in `EF Core` has released a new version. The new version adds support for `.NET 6`, supports `ValueConverter` during batch data insertion, and completely solves the `"The count of columns should be even" exception that occurs when two column expressions are equivalent during data update`.
Next, we will talk about database-related content, focusing on ASP.NET Core and EF Core. Only if there is a need to modify the page, we will mention Blazor. This part will take up more space.
Entities in EntityFramework Core do not directly support operations on enum types, which brings us a lot of trouble during development.
Many-to-many relationships are not as simple as other relationships. In this article, I will show you how to create many-to-many relationships and how to use them in EF Core.