NET Core 介绍:https://docs.microsoft.com/zh-cn/ef/core/miscellaneous/connection-strings
1.NuGet控制台执行以下操作:
Install-Package Microsoft.EntityFrameworkCore.SqlServer
Install-Package Microsoft.EntityFrameworkCore.Tools
Install-Package Microsoft.VisualStudio.Web.CodeGeneration.Design
2.修改appsettings.json
文件的链接字符串
https://docs.microsoft.com/zh-cn/ef/core/miscellaneous/connection-strings
{ "ConnectionStrings": { "BloggingDatabase": "Server=(localdb)\\mssqllocaldb;Database=EFGetStarted.ConsoleApp.NewDb;Trusted_Connection=True;" }, }
3.包管理控制台默认项目切换到相应项目,具体命令行
https://docs.microsoft.com/zh-cn/ef/core/miscellaneous/cli/dotnet
运行:
Scaffold-DbContext "Data Source=192.168.110.129;Initial Catalog=yourDB;User Id=yourUserId;Password=yourPassword" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models -UseDatabaseNames -Force -v
命令最后的-v就是打开错误提示,命令行运行时如果发现错误则会提示
之后会在你选择的项目下面生成实体类