MySQL Bugs: #78204: S0426: The type name 'Data' does not exist in the type 'MySql'

Bug #78204	S0426: The type name 'Data' does not exist in the type 'MySql'
Submitted:	25 Aug 2015 9:37	Modified:	28 Aug 2015 9:41
Reporter:	AAA ZZZ	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Visual Studio Integration	Severity:	S2 (Serious)
Version:	1.1.1.1	OS:	Windows
Assigned to:		CPU Architecture:	Any
Tags:	S0426: The type name 'Data' does not exist in the type 'MySql'

Description:
Hi Team,

I have installed my sql server 5.0 and My SQL for visual studio 1.1.1.1. and My Sql connector.

So using C# , i am trying to add value in table but showing error in namespae MYSQL.Data.MySqlClient;

Error Descripction;  S0426: The type name 'Data' does not exist in the type 'MySql'

How to Resolve?

How to repeat:
Create table in MySql,
Create web application,
Add Dll Files in Bin Flder(all dll present unser connector Assembly folder)

Then 

in Code Behind;
using MySql.Data.MySqlClient added,

and code for insert using MysQLcLIENT cLASS

bUT IT IS SHOWING ERROR at namespace using MySql.Data.MySqlClient.

showing Below error:
S0426: The type name 'Data' does not exist in the type 'MySql'

Kindly help toresolve the same.

Hello AAA,

Thank you for the bug report.
It seems "MySql.Data" dll was missing your project, follow one of the step to add the  "MySql.Data" dll to the project.

1). Goto Project->Add reference-> Browse path (C:\Program Files (x86)\MySQL\Connector.NET 6.9\Assemblies\v4.0 or v4.5) from "MySql.Data" dll 
2). PM> Install-Package MySql.Data (install "MySQL.Data" at Package Manager Console).
3). Goto Project->Manage NuGet Packages and search for "MySql.Data.Entity"  and install.

MySQL Installing and Configuring manual for Visual Studio Integration:
http://dev.mysql.com/doc/connector-net/en/connector-net-visual-studio-install.html

Thanks,
Chiranjeevi.

HI Chiranjeevi,

Thanks for Quick reply.

I have opted first open added dll in BIn folder. and previously also i have added dll. Then why it is showing error( I have tried on other system by installing MY SQL Installer)
But it is not working.

Can you please help me on this.
Needed help urgently.

Hello !,

Thank you for your feedback.
Could you please install and try "MySQL for Visual Studio" 1.2.3/ 1.2.4 and Connector/NET 6.9.7.
Download from here: 
http://dev.mysql.com/downloads/windows/visualstudio/1.2.html
https://dev.mysql.com/downloads/connector/net/6.9.html

Still if you are facing issue, please let us know the details of  Visual Studio version and MySQL Visual Studio Integration won't work for Visual Studio express version.

Thanks,
Chiranjeevi.

HI Chirnjevee,

Thank you for your help.

I have resolved the issue.

Now i want to insert excel data into mysql table.Can you please suggest.

Regards,
AAA

Hello !,

Thank you for your feedback.
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.

Thanks,
Chiranjeevi.