cant use a MySql connection for EF 6

Question

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

Sachin Singh · Answer

Download the following MySql for visual studio MySql Connector/NET v6 .10 .7 NuGet packages: Entityframework v6 .1.3 MySql .Data v6 .10.7 MySql .Data .Entity v6 .10.7 modify web.config as "MySql.Data.MySqlClient" type= "MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity.EF6" />

Rijwan Ansari · Answer

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

Sachin Singh · Answer

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.

Sachin Singh · Answer

@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).

cant use a MySql connection for EF 6

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (4)