MVc:Type is not resolved for member 'MySql.Data.MySqlClient.

Harshal Thakre

using code first approch whlle update database getting error:-

Type is not resolved for member 'MySql.Data.MySqlClient.MySqlException,MySql.Data, Version=6.9.9.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d'.

note:- while creating table in database works fine but when we do some modification in code

(alter any columns) then getting above error.

3 Replies

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

Harshal Thakre9y ago
hi friends,
i have alternative but this is not good way because we have to type query to implement this.

public override void Up() {

comment this
// RenameColumn(table: "dbo.Course", name: "CourseNameHello", newName: "CourseName");

// add line

Sql(------------write ur sql alter qurey here------------------ ) ;

}

PM> Update-Database
Harshal Thakre9y ago
Hi rajeev,

i am using
mysql.data version:- 6.9.9.0
and mysql.data.entity version :- 6.9.9.0

Code:
public override void Up()
{
RenameColumn(table: "dbo.Course", name: "CourseNameHello", newName: "CourseName");
}

PM> Update-Database

Getting above error.
Rajeev Punhani9y ago
Hi Harshal,
Please use the latest MySQL connector as there was an issue in previous versions. Also check whether your MySQL is running and you are able to connect to it. This issue mainly occurs when you are updating any changes to table and your MySQL connector is not supporting it. Please see the below link https://blogs.oracle.com/MySqlOnWindows/entry/entity_framework_4_3_1