作者:糖糖菓子 | 来源:互联网 | 2023-09-09 19:41
篇首语:本文由编程笔记#小编为大家整理,主要介绍了MySqlScaffoldinganExistingDatabaseinEFCore相关的知识,希望对你有一定的参考价值。
篇首语:本文由编程笔记#小编为大家整理,主要介绍了MySql Scaffolding an Existing Database in EF Core相关的知识,希望对你有一定的参考价值。
官方文档详见:https://dev.mysql.com/doc/connector-net/en/connector-net-entityframework-core-scaffold-example.html
Scaffolding a Database Using Package Manager Console in Visual Studio
Open Visual Studio and create a new Console App (.NET Core) for C#.
Add the MySQL NuGet package for EF Core using the
Install-Package MySql.Data.EntityFrameworkCore -Version 8.0.13
Note
The version (for example, -v 8.0.13
) must match the actual Connector/NET version you are using. For current version information, seeTable 9.2, “Supported versions of Entity Framework Core”.
Install the following NuGet packages by selecting either
Microsoft.EntityFrameworkCore.Design
EF Core 1.1 only: Also add the MySql.Data.EntityFrameworkCore.Design
package.
Microsoft.EntityFrameworkCore.Tools version 1.1.6
(for EF Core 1.1) and Microsoft.EntityFrameworkCore.Tools version 2.0.3
(for EF Core 2.0)
Note
The .NET tools are included in the .NET Core 2.1 SDK and not required or supported for EF Core 2.1. If this is an upgrade, remove the reference to that package from the .csproj
file (version 2.0.3 in this example) :
Include="Microsoft.EntityFrameworkCore.Tools.DotNet" Version="2.0.3" />
Open
Scaffold-DbContext "server=localhost;port=3306;user=root;password=mypass;database=sakila" MySql.Data.EntityFrameworkCore -OutputDir sakila -f
Visual Studio creates a new sakila
folder inside the project, which contains all the tables mapped to entities and the sakilaContext.cs
file.