How to connect to MySQL in Visual Studio 2013?

E

EVOSandru62014-09-22 13:46:59

MySQL

EVOSandru6, 2014-09-22 13:46:59

In VS 2010, I right-clicked on the project -> Common Files->Add New Reference->.NET->Mysql.Data
In the 2013 version, there is no .NET item in the "Add New Reference" window. I tried to do as in the article andrey.moveax.ru/post/installing-mysql-connector-i...
, downloaded the conetcore from dev.mysql.com/downloads/connector/net , put the installer in the folder, crawled through cmd to this folder and typed the following command:
msiexec /a mysql-connector-net-6.9.3.msi /qb TARGETDIR=S:\DEVELOPER\MVS\MySQLConnectorFix\Unpacked

To which I am given the answer
"msiexec" is not an internal or external
command executable by the program or batch file.
%SystemRoot%\System32 is in the PATH variable.
C:\Windows\System32\msiexec.exethere is.
Help me get connected to Mysql!!!

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

M

Mephistophele, 2014-10-02
@Mephistophele

You need to try through Ado.Net
I.e. download the assembly from the mysql website, connect it and that's it.
dev.mysql.com/downloads/connector/net/6.9.html
msdn.microsoft.com/en-us/data/dd363565.aspx
www.cyberforum.ru/ado-net/thread609050.html
Or using EF:
dev. mysql.com/doc/connector-net/en/connector-net-v...

I

isol, 2014-10-03
@isol

I don't understand why you use the /a option when installing. This option means Administrative install - Installs a product on the network. Perhaps this is the reason for the message that msiexec was not found.
If you have downloaded mysql-connector-net-6.9.3.msi on the machine where Visual Studio is installed, then you just need to right-click on it and select 'Install'. And that's it.