Bug #94420 installer does not install correct files
Submitted: 21 Feb 2019 10:26 Modified: 28 Feb 2020 19:07
Reporter: Ηλίας Ηλιάδης Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Visual Studio Integration Severity:S2 (Serious)
Version:1.4.28.0 OS:Windows (10)
Assigned to: CPU Architecture:Any

[21 Feb 2019 10:26] Ηλίας Ηλιάδης
Description:
I have installed VS2017 community edition. I have Mysql installed in different computer so I do not want to install anything else than MySQL for Visual Studio as well as the Connector/NET.
This gives me the "common" problem "You have a usable connection already".

Selecting at first MySQL for Visual Studio and ONLY the components for visual studio community edition shows that install runs everything else except 2017 (alone) or 2017_community
Installer create (and later deletes) reg keys for almost everything but not the requested. Has some VS15 functions (SetVS15Setup_Custom, VS15Setup_Custom etc) which seem suspicious. Also although I see names like  _VS2017_Ent and _VS2017_Pro
nothing for either _VS2017 or _VS2017_Community (or alike) shows up, giving the impression that VS2017 is not installed (Since I deselected pro and enterprise)

Attached file is from "show details" during installation of MySQL for Visual Studio.

How to repeat:
Install Microsoft Visual Studio Community 2017 Version 15.9.7
Install MySQL Installer 1.4.28.0

Install MySQL for Visual Studio and ONLY the components for visual studio community edition
(here you will have the above output which maybe the whole problem)

Install Connector/NET for Visual Studio 2017 community
Create a winform application

Try to create a data source from any MySQL server. Of course using credentials that will return a usable connection...)
(Menu->Project->Add New Data Source
Choose a Data Source Type => Database
Choose a Database Model => Dataset
Establish connection, check the tables
[21 Feb 2019 10:27] Ηλίας Ηλιάδης
show details during installation of  MySQL for Visual Studio 1.2.8

Attachment: showdetails.txt (text/plain), 17.75 KiB.

[21 Feb 2019 17:38] Ηλίας Ηλιάδης
Installer installs 
MySQL.Data v 8.0.15.0 in GAC
and
MySQL.Data.dll version 6.10.7.0 in C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\Common7\IDE\PrivateAssemblies
(with the same PublicKeyToken)
thus making usage in IDE impossible. 

TableAdapter Configuration Wizard returns:

Generated SELECT statement. 
[A]MySql.Data.MySqlClient. MySqlConnection cannot be cast to [B]MySql.Data.MySqlClient. MySqlConnection. Type A originates from "MySql.Data, Version=6.10.7.0, Culture=neutral, PublicKeyToken=5687fc82969c4dd' in the context ‘Default’ at location "C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\Common7\IDE\PrivateAssemblies\MySql.Data.d IV. Type B originates from ‘MySql.Data, Version=8.0.15.0, Culture=neutral, PublicKeyToken=5687fc82969c4dd' in the context ‘Default’ at location "C\Windows\Microsoft.Net\assembly\GAC_MSIL\MySql.Data\v4.0 2.0.15. 0_c5687fc88969c44d\MySq.Data.dll
[25 Apr 2019 7:09] MySQL Verification Team
Bug #95121 marked as duplicate of this one
[3 May 2019 10:32] Rikus Jansen
And the work around? Hello, how to resolve?
[7 May 2019 8:11] Rikus Jansen
So no answers. Like dealing with a useless government
[28 Jan 2020 19:07] MySQL Verification Team
Please check latest released version. Thanks.
[29 Feb 2020 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".