ef core数据库模型
创建数据库模型
Scaffold-DbContext -Connection “Data Source=.;Initial Catalog=YTTDB;User ID=sa;Password=123456;MultipleActiveResultSets=true” -Provider “Microsoft.EntityFrameworkCore.SqlServer” -OutputDir “Models/YTTDB”
更新数据库模型
Scaffold-DbContext -force -Connection “Data Source=.;Initial Catalog=YTTDB;User ID=sa;Password=123456;MultipleActiveResultSets=true” -Provider “Microsoft.EntityFrameworkCore.SqlServer” -OutputDir “Models/YTTDB”
版本过高时添加TrustServerCertificate=true
Scaffold-DbContext -Connection “Data Source=.;Initial Catalog=erp_user;User ID=sa;Password=123456;TrustServerCertificate=true;MultipleActiveResultSets=true” -Provider “Microsoft.EntityFrameworkCore.SqlServer” -OutputDir “Models/erp_user”-v