2023年12月4日 星期一

.Net Core Scaffold-DbContext複數化問題及不產生不產生OnConfiguring

早上寫好程式後更新Model卻發生了以下問題
Cannot create a DbSet for 'xxxMinutes' because this type is not included in the model for the context.
後來找了一下xxxMinutes多了一個xxxMinute的Class
原來的
Scaffold-DbContext "Server=192.168.0.1;Database=abc;user id=sa;password=12345678;TrustServerCertificate=true;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models  -Project board.model  -UseDatabaseNames -NoOnConfiguring -Force   
多加一個-NoPluralize停止複數化
多加一個-NoOnConfiguring不產生OnConfiguring
Scaffold-DbContext "Server=192.168.0.1;Database=abc;user id=sa;password=12345678;TrustServerCertificate=true;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models  -Project board.model  -UseDatabaseNames -NoOnConfiguring -NoPluralize -Force   
參考資料
Entity Framework Core tools reference - Package Manager Console in Visual Studio