Connection entity framework with mysql C #

Question

0.00/5 (No votes)

See more:

Hello,
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:

http://i.stack.imgur.com/UrZWO.png[^]

What I have tried:

Connection Entity Framework with MySQL C #

Posted 21-Sep-16 23:53pm

ThabetMicrosoft

Updated 22-Sep-16 4:55am

v5

Add a Solution

Comments

David_Wimbley 22-Sep-16 9:15am

Can you post your app.config?

[no name] 22-Sep-16 9:25am

Post the actual error. Not everyone can view an image stored somewhere. And it doesn't help people in the future.

2 solutions

Solution 3

Follow the instruction here:
MySQL :: MySQL Connector/Net Developer Guide :: 9 EF6 Support[^]
Entity Framework Config File Settings[^]
Entity Framework Connection Management[^]
Entity Framework (EF) Documentation[^]

Posted 22-Sep-16 4:55am

Maciej Los

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ThabetMicrosoft · Accepted Answer · 2016-09-22T04:50:00

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:

XML

It works for me !!