[Solved] MySql Error: The data provider MySql.Data.MySqlClient could not be found in the system configuration

Hi

I converted from SQL server to mysql after recommendation from Microsoft?

I had change all references to

Imports System.Data.SqlClient to be Imports MySql.Data.MySqlClient

I then changed the Web.config to be

<connectionStrings>
<add name="SchoolDataConnectionString" connectionString="server=localhost;Initial Catalog=SchoolData; User Id=root; Password=########" providerName="MySql.Data.MySqlClient" />
</connectionStrings>
<system.data>
    <DbProviderFactories>
        <add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory,MySql.Data" />
        <add name="dotConnect for MySql" invariant="Devart.Data.MySql" description="Devart dotConnect for MySql" type="Devart.Data.MySql.MySqlProviderFactory, Devart.Data.MySql, Version=8.19.1985.0, Culture=neutral, PublicKeyToken=09af7300eec23701" />
    </DbProviderFactories>
</system.data>

Added References

MySql.Data Runtime version - v4.0.30319 Version - 8.0.31.0

MySql.Data.EntityFramework Runtime version - v4.0.30319 Version - 8.0.30.0

MySql.Web Runtime version - v4.0.30319 Version - 8.0.31.0

MySqlBackup Runtime version - v4.0.30319 Version - 2.3.6.1

MySqlBackupNet.DevartExpress Runtime version - v4.0.30319 Version - 2.3.6.0

MySqlBackupNet.MySqlConnector Runtime version - v4.0.30319 Version - 2.3.6.0

MySqlConnector Runtime version - v4.0.30319 Version - 1.0.0.0

If I add a system.web.ui.WebControls.SqlDataSource goto configure data source I get Error

The data provider MySql.Data.MySqlClient could not be found in the system configuration

Unable to find the requested .Net Framework Data Provider. It may not be installed.

If I go to the .aspx and edit the code 

<asp:SqlDataSource ID="dsStaff" runat="server" ConnectionString="<%$ ConnectionStrings:SchoolDataConnectionString %>" SelectCommand="SELECT id, FirstN, LastN FROM StaffMaster ORDER BY FullN " ProviderName="<%$ ConnectionStrings:SchoolDataConnectionString.providerName%>"></asp:SqlDataSource>