Error while connecting MYSQL with asp.net core

Question

Problem

I am trying to conect MY SQL with my asp.net core 2.0 web application. But it throug me this error

Method 'Clone' in type 'MySql.Data.EntityFrameworkCore.Infraestructure.Internal.MySQLOptionsExtension' from assembly 'MySql.Data.EntityFrameworkCore, Version=6.10.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' does not have an implementation.

I am using Repository pattern in asp.net core 2.0 with EF 2.0

startup.cs

here the error occurs

services.AddDbContext<MyContext>(options => 
            options.UseMySQL(
                Configuration.GetConnectionString("DefaultConnection"),
                b=>b.MigrationsAssembly("AspNetCoreMultipleProject")
                ));

looks like you can't use the "clone" method with this library — ADyson
– ADyson, Commented Dec 5, 2017 at 11:58
any thing which helps me. I am using mysql with asp.net core very first time and I already searched a lot but not find any thing good — Malik Kashmiri
– Malik Kashmiri, Commented Dec 5, 2017 at 12:00

majita · Accepted Answer · 2017-12-06 08:52:47Z

1

It looks like this could be because the official MySQL provider doesn't work with EF core 2.0 - GitHub issue.

The suggested workaround is to use the Pomelo provider - MS documentation

answered Dec 6, 2017 at 8:52

majita

1,34614 silver badges25 bronze badges

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

1 Comment

Malik Kashmiri Over a year ago

I changed it to UseMySql but now it show me this error > "Unable to connect to any of the specified MySQL hosts."

Collectives™ on Stack Overflow

Error while connecting MYSQL with asp.net core

Problem

startup.cs

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Problem

startup.cs

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related