.Net Core 2.0数据库第一种方法Mysql DB的Scaffold-DbContext

发布时间：2020-12-12 06:33:13 所属栏目：MsSql教程来源：网络整理

导读：我正在使用 MySQL DB在.Net Core 2.0中开发WEB API.我正在尝试搭建MySQL DB.我跟随 This link (MySQL Official Site)但是当我解除脚手架命令时我得到了错误我在下面提到过,如果我做错了什么,请告诉我. 脚手架命令(在包管理器控制台中触发) Scaffold-DbContext

我正在使用 MySQL DB在.Net Core 2.0中开发WEB API.我正在尝试搭建MySQL DB.我跟随 This link (MySQL Official Site)但是当我解除脚手架命令时我得到了错误我在下面提到过,如果我做错了什么,请告诉我.
脚手架命令(在包管理器控制台中触发)

Scaffold-DbContext "server=localhost;port=3306;user=root;password=darshan7826;database=sakila" MySql.Data.EntityFrameworkCore -OutputDir sakila -f

执行上述命令时出错

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.RelationalScaffoldingModelFactory.Create(String connectionString,IEnumerable`1 schemas,Boolean useDatabaseNames)
at Microsoft.EntityFrameworkCore.Scaffolding.Internal.ModelScaffolder.Generate(String connectionString,String projectPath,String outputPath,String rootNamespace,String contextName,Boolean useDataAnnotations,Boolean overwriteFiles,Boolean useDatabaseNames)
at Microsoft.EntityFrameworkCore.Design.Internal.DatabaSEOperations.ScaffoldContext(String provider,String connectionString,String outputDir,String dbContextClassName,Boolean useDatabaseNames)
at Microsoft.EntityFrameworkCore.Design.OperationExecutor.ScaffoldContextImpl(String provider,IEnumerable`1 schemaFilters,IEnumerable`1 tableFilters,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 Core 2.0 Mysql Connector无法正常工作
经过一些搜索和RnD我发现堆栈溢出 Pomelo Foundation我尝试了它,它的工作原理.

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!