cant use a MySql connection for EF 6

Guest User

5y762Learn iOS Programming

when i try to connect MySql for EntityFramework 6. I get the message.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
Accepted answer
Download the following
1. MySql for visual studio
2. MySql Connector/NET v6.10.7
NuGet packages:
1. Entityframework v6.1.3
2. MySql.Data v6.10.7
3. MySql.Data.Entity v6.10.7
```
modify web.config as
```
         "MySql.Data.MySqlClient"
              type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity.EF6" />
+1
Rijwan Ansari5y ago
You can surely use mysql with EF 6, You will find Step by Step in this blog.
https://dev.mysql.com/doc/connector-net/en/connector-net-entityframework60.html
+2
Sachin Singh5y ago
sometimes the above code i mentioned doesn't work
then follow below steps
step 1.
Install-Package MySql.Data.EntityFramework -Version 8.0.22
step 2 modify web.config as
    "MyContext" providerName="MySql.Data.MySqlClient"
        connectionString="server=localhost;port=3306;database=mycontext;uid=root;password=********"/>


    "System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework"/>

        "MySql.Data.MySqlClient"
            type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.EntityFramework"/>
        "System.Data.SqlClient"
            type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer"/>


Note :- the providers section is important.
+2
Sachin Singh5y ago
@Nivi Sharma
please go to pacakage manager console (Right click on project --->Manage Nuget Packages--->Package Manager Console)
and copy paste below lines of code and hit enter.
Install-Package MySql.Data.Entity -Version 6.10.9
while working , don't forget to add using statements (ctrl+dot) for importing necessary packages
also make sure you are using MySql and MS SQL , we usually use Microsoft SQL Server (MS SQL).
+1