EF Core – 7.0 New Features

前言

这篇不会细谈功能, 只是一个总链接.

参考

Docs – What's New in EF Core 7.0

Breaking Change

我 follow EF Core – 搭建单侧环境 做了一遍, 在运行 dotnet ef database update 后就出现了 error

A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)

其原因是 EF Core 7.0 依赖了 Microsoft.Data.SqlClient 5.0.0

Github Issue – EFCore.SqlServer 6.0.1 Untrusted certificate authority error

而 Microsoft.Data.SqlClient 4.0.0 的时候有一个 breaking change 

解决方法有好几个

参考: Stack Overflow – "The certificate chain was issued by an authority that is not trusted" when connecting DB in VM Role from Azure website

最简单的是在 ConnectionStrings 加上 TrustServerCertificate=True, 变成这样

Server=192.168.1.152;Database=EFCore7;Trusted_Connection=True;MultipleActiveResultSets=true;TrustServerCertificate=True

这个 for development 情况下是可以的, 在 production 的时候就不太理想了. 但我目前还没有 EF Core 7.0 production 的项目, 之后才研究 TODO...

JSON Columns

ExecuteUpdate and ExecuteDelete (Bulk updates)