.Net Core 2.0 Database First Approach Scaffold-DbContext of Mysql DB

Question

I am developing WEB API in .Net Core 2.0 with MySQL DB. I am trying to scaffolding MySQL DB. I have follow This link (MySQL Official Site) but when I fire scaffolding command I getting error both I have mention below, please do let me know if I am doing anything wrong. Command For Scaffolding(firing in Package Manager Console)

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

Error on executing above command

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 tables, IEnumerable`1 schemas, Boolean useDatabaseNames)
at Microsoft.EntityFrameworkCore.Scaffolding.Internal.ModelScaffolder.Generate(String connectionString, IEnumerable`1 tables, IEnumerable`1 schemas, 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, 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 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.

Darshan Dave · Accepted Answer · 2018-02-01 13:07:01Z

8

After digging i found that .Net Core 2.0 Mysql Connector is not working properly and after some search and RnD i found Pomelo Foundation from Stack overflow i tried it and it works.

answered Feb 1, 2018 at 13:07

Darshan Dave

6352 gold badges10 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

DavidG · Accepted Answer · 2017-12-23 13:40:00Z

4

Taking a look at the official sourcecode for the MySQL Connector for .Net, you can see that it's not complete yet due to this:

public DatabaseModel Create(string connectionString, 
    IEnumerable<string> tables, IEnumerable<string> schemas)
{
  throw new NotImplementedException();
}

You may want to open up a bug report on the official bug tracker.

Alternatively, there does seem to be a much newer beta version that you could look at trying. https://www.nuget.org/packages/MySql.Data.EntityFrameworkCore/8.0.9-dmr

edited Dec 23, 2017 at 13:40

answered Dec 23, 2017 at 13:34

DavidG

120k13 gold badges232 silver badges239 bronze badges

5 Comments

Ivan Stoev Over a year ago

Lol, throw new NotImplementedException(); is pretty "standard" implementation.

DavidG Over a year ago

@Ivan It's how I implement all my code too, you'd be amazed how quickly I can write it!

Darshan Dave Over a year ago

@DavidG thanks for answer, can you please let me know in file i have to add this block

Sunny Tambi Over a year ago

It is still not implemented even with newest release of 8.0.10-rc which got released just 2 days ago :(

Neville Nazerane Over a year ago

its odd how they have a release and this function is still not implemented

Zoe - Save the data dump · Accepted Answer · 2019-02-17 13:28:45Z

1

You should run this (from Package-Manager-Console):

Scaffold-DbContext "Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;" 
MySql.Data.EntityFrameworkCore -OutputDir Models

or use:

dotnet ef dbcontext scaffold

Note: You should be at the project in which MySql.Data.EntityFrameworkCore NuGet package has been added.

edited Feb 17, 2019 at 13:28

Zoe - Save the data dump

28.4k22 gold badges130 silver badges163 bronze badges

answered Feb 17, 2019 at 11:49

M. Artem

8118 silver badges8 bronze badges

Collectives™ on Stack Overflow

.Net Core 2.0 Database First Approach Scaffold-DbContext of Mysql DB

3 Answers 3

Comments

5 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related