How to make good use of EFCore in a production environment
This is the second article in a series on migrating databases using EF Core.
This is the second article in a series on migrating databases using EF Core.
Yesterday, my friends in the ". NET Big Bull Road" group talked about using EF Core to implement the warehousing model. I remembered reading an article written by a foreign boss before and thought it was very valuable for reference.
When using EF Core, you often need to know what SQL statements EF Core actually executes.
Several suggestions
I won't go into details here about what Dapper is (detailed entry); this article only provides a brief explanation of the use of Dapper in. NET Core. The code described is mainly explained by examples, which is a reminder. Developers can expand and adjust according to their own needs.
A new version of the framework 'Zack.EFCore.Batch' that performs 'updates','deletes', and 'inserts' of data in 'EF Core' has been released. The new version adds support for '. NET 6' and supports 'ValueConverter' when data is inserted in batches, completely solving the 'The count of columns should be even exception that occurs when the expressions of two columns are equivalent' when updating data.
Entities in Entity Framework Core do not directly support enumeration type operations, which caused us a lot of trouble during the development process
Many-to-many relationships are not as simple as other relationships, and in this article I will show you how to create many-to-many relationships and how to use them in EF Core.