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

[21 Feb 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 10:27] Ηλίας Ηλιάδης
show details during installation of  MySQL for Visual Studio 1.2.8

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

[21 Feb 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 7:09] Umesh Shastry
Bug #95121 marked as duplicate of this one
[3 May 10:32] Rikus Jansen
And the work around? Hello, how to resolve?
[7 May 8:11] Rikus Jansen
So no answers. Like dealing with a useless government