Error: Connection Entity Framework with MySQL C #

Question

I have configured all necessary to connect with MySQL with Entity Framwork in Visual Studio 2012

And all this is going well,

I get the mapping of my table in my code,

here is my code:

 using (testuserEntities context = new testuserEntities())
        {
            personels nam = context.personels.FirstOrDefault(x => x.name == "Walid");
            if (nam !=null )
            {
                textBox1.Text = nam.name;
            }                
        }

In the execution, I get the ERROR:

Thnaks,

The connection Strings :

<connectionStrings>
<add name="testuserEntities" connectionString="metadata=res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl;provider=MySql.Data.MySqlClient;provider connection string=&quot;server=localhost;user id=root;password=root;persistsecurityinfo=True;database=testuser&quot;" providerName="System.Data.EntityClient"/>

my table :

can you share your connection string and context class ? — Sampath
– Sampath, Commented Sep 22, 2016 at 9:46
You need to make sure the provider is correctly registered, have a look at the link @Alex shared — ogrim
– ogrim, Commented Sep 22, 2016 at 9:50

devtunis · Accepted Answer · 2016-09-22 14:48:12Z

2

I find the solution: We must update the DLL:

1) Right click on the Solution (top level in the solution explorer)

2) Manage Nuget packages for solution

3) Go to update ( locate in the left)

4) Update the packages :MySql.Data, MySql.Data.Entities, Entity.Framwork

we have change in the App.config file:

<system.data>
<DbProviderFactories>
  <remove invariant="MySql.Data.MySqlClient" />
  <add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=6.9.9.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />
</DbProviderFactories>

It works for me !!

answered Sep 22, 2016 at 14:48

devtunis

1411 silver badge13 bronze badges

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

Collectives™ on Stack Overflow

Error: Connection Entity Framework with MySQL C #

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related