gpt4 book ai didi

mysql - 使用 MySql 现有数据库的 ASP.NET Core 逆向工程模型

转载 作者:行者123 更新时间:2023-11-29 17:22:50 25 4
gpt4 key购买 nike

我尝试使用 EF Codefirst 和现有的 MySql 数据库创建一个 ASP.NET Core 项目当我尝试进行逆向工程时(以下文章:Getting Started with EF Core on ASP.NET Core with an Existing Database)

我有一个错误。我的MySql包是:MySql.Data.EntityFrameworkCore -版本8.0.11

我的数据库是:TEST我的 table 是

CREATE TABLE USER (
ID BIGINT(20) NOT NULL AUTO_INCREMENT,
USERNAME VARCHAR(50) NOT NULL,
FIRSTNAME VARCHAR(50) NOT NULL
) ENGINE=InnoDB;

我使用命令:

Scaffold-DbContext "server=localhost;port=3306;user=root;password=123;database=TEST" MySql.Data.EntityFrameworkCore -OutputDir Models

错误:

System.NotImplementedException: The method or operation is not implemented.
at MySql.Data.EntityFrameworkCore.Scaffolding.Internal.MySQLDatabaseModelFactory.Create(String connectionString, IEnumerable`1 tables, IEnumerable`1 schemas)
at Microsoft.EntityFrameworkCore.Scaffolding.Internal.ReverseEngineerScaffolder.ScaffoldModel(String connectionString, IEnumerable`1 tables, IEnumerable`1 schemas, String namespace, String language, String contextDir, String contextName, ModelReverseEngineerOptions modelOptions, ModelCodeGenerationOptions codeOptions)
at Microsoft.EntityFrameworkCore.Design.Internal.DatabaseOperations.ScaffoldContext(String provider, String connectionString, String outputDir, String outputContextDir, String dbContextClassName, IEnumerable`1 schemas, IEnumerable`1 tables, Boolean useDataAnnotations, Boolean overwriteFiles, Boolean useDatabaseNames)
at Microsoft.EntityFrameworkCore.Design.OperationExecutor.ScaffoldContextImpl(String provider, String connectionString, String outputDir, String outputDbContextDir, String dbContextClassName, IEnumerable`1 schemaFilters, IEnumerable`1 tableFilters, Boolean useDataAnnotations, Boolean overwriteFiles, Boolean useDatabaseNames)
at Microsoft.EntityFrameworkCore.Design.OperationExecutor.ScaffoldContext.<>c__DisplayClass0_1.<.ctor>b__0()
at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.<>c__DisplayClass3_0`1.<Execute>b__0()
at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.Execute(Action action)
The method or operation is not implemented.

有人知道我怎样才能卖这个吗?如果使用 .NET Framework 中的 ASP.NET Web API 之类的向导,有没有办法制作模型?

最佳答案

试试这个,它对我有用。这也是 NET Core 兼容的 MySQL 连接器 + EF Core MySQL 提供程序:

Pomelo.Data.MySql      
Pomelo.EntityFrameworkCore.MySql
Pomelo.EntityFrameworkCore.MySql.Design

关于mysql - 使用 MySql 现有数据库的 ASP.NET Core 逆向工程模型,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/51164998/

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com