I did some studies on American StackOverflow regarding this case and I was not successful. When I try to access my link page, I get the message below:
The Entity Framework provider type 'MySql.Data.MySqlClient.MySqlProviderServices, EntityFramework.MySqlServer' registered in the application config file for the ADO.NET provider with invariant name 'MySql.Data.MySqlClient' could not be loaded. Make sure that the assembly-qualified name is used and that assembly is available to the running application. See link for more information. *
I do not know if the problem is in the web.config
file or if there is no reference to the MySQL database in the project available on the web.
The following is the file Web.Config
available on the host:
<?xml version="1.0" encoding="UTF-8"?>
<!--
For more information on how to configure your ASP.NET application, please visit
https://go.microsoft.com/fwlink/?LinkId=301880
-->
<configuration>
<configSections>
<!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
<section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
</configSections>
<appSettings>
<add key="webpages:Version" value="3.0.0.0" />
<add key="webpages:Enabled" value="false" />
<add key="ClientValidationEnabled" value="true" />
<add key="UnobtrusiveJavaScriptEnabled" value="true" />
</appSettings>
<system.web>
<customErrors mode="Off" />
<compilation targetFramework="4.6.1" debug="true" urlLinePragmas="true" />
<httpRuntime targetFramework="4.6.1" />
<httpModules>
<add name="ApplicationInsightsWebTracking" type="Microsoft.ApplicationInsights.Web.ApplicationInsightsHttpModule, Microsoft.AI.Web" />
</httpModules>
<identity password="***" userName="***" />
</system.web>
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name="Newtonsoft.Json" culture="neutral" publicKeyToken="30ad4fe6b2a6aeed" />
<bindingRedirect oldVersion="0.0.0.0-6.0.0.0" newVersion="6.0.0.0" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="System.Web.Optimization" publicKeyToken="31bf3856ad364e35" />
<bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="1.1.0.0" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="WebGrease" publicKeyToken="31bf3856ad364e35" />
<bindingRedirect oldVersion="0.0.0.0-1.5.2.14234" newVersion="1.5.2.14234" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="System.Web.Helpers" publicKeyToken="31bf3856ad364e35" />
<bindingRedirect oldVersion="1.0.0.0-3.0.0.0" newVersion="3.0.0.0" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="System.Web.WebPages" publicKeyToken="31bf3856ad364e35" />
<bindingRedirect oldVersion="1.0.0.0-3.0.0.0" newVersion="3.0.0.0" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="System.Web.Mvc" publicKeyToken="31bf3856ad364e35" />
<bindingRedirect oldVersion="1.0.0.0-5.2.3.0" newVersion="5.2.3.0" />
</dependentAssembly>
</assemblyBinding>
</runtime>
<system.webServer>
<validation validateIntegratedModeConfiguration="false" />
<modules>
<remove name="ApplicationInsightsWebTracking" />
<add name="ApplicationInsightsWebTracking" type="Microsoft.ApplicationInsights.Web.ApplicationInsightsHttpModule, Microsoft.AI.Web" preCondition="managedHandler" />
</modules>
<httpProtocol>
<customHeaders>
<add name="Cache-Control" value="public" />
</customHeaders>
</httpProtocol>
<urlCompression doDynamicCompression="false" />
<defaultDocument enabled="true">
<files>
<add value="index.htm" />
<add value="index.html" />
<add value="index.php" />
<add value="index.asp" />
<add value="default.asp" />
<add value="index.aspx" />
<add value="default.aspx" />
</files>
</defaultDocument>
<handlers>
<add name="PHP-FastCGI7.1" path="*.php" verb="*" modules="FastCgiModule" scriptProcessor="C:\php7.1\php-cgi_2.exe" resourceType="File" />
</handlers>
</system.webServer>
<system.codedom>
<compilers>
<compiler language="c#;cs;csharp" extension=".cs" type="Microsoft.CodeDom.Providers.DotNetCompilerPlatform.CSharpCodeProvider, Microsoft.CodeDom.Providers.DotNetCompilerPlatform, Version=1.0.8.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" warningLevel="4" compilerOptions="/langversion:default /nowarn:1659;1699;1701" />
<compiler language="vb;vbs;visualbasic;vbscript" extension=".vb" type="Microsoft.CodeDom.Providers.DotNetCompilerPlatform.VBCodeProvider, Microsoft.CodeDom.Providers.DotNetCompilerPlatform, Version=1.0.8.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" warningLevel="4" compilerOptions="/langversion:default /nowarn:41008 /define:_MYTYPE=\"Web\" /optionInfer+" />
</compilers>
</system.codedom>
<connectionStrings>
<add name="PersonalWEntities" connectionString="Server=mysql.***.com;Database=***;Uid=***;Pwd=***;" providerName="MySql.Data.MySqlClient" />
</connectionStrings>
<!--
connectionString="metadata=res://*/ModelEntity.csdl|res://*/ModelEntity.ssdl|res://*/ModelEntity.msl;provider=System.Data.SqlClient;Server=mysql.wellwaps.com;Initial Catalog=***;Persist Security Info=False;User ID=***;Password=***;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"
<add name="PersonalWEntities" connectionString="metadata=res://*/ModelEntity.csdl|res://*/ModelEntity.ssdl|res://*/ModelEntity.msl;provider=System.Data.SqlClient;provider connection string="Server=mysql.***.com;Initial Catalog=***;Persist Security Info=False;User ID=***;Password=***;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;;App=EntityFramework""
System.Data.EntityClient
<add name="PersonalWEntities" connectionString="Server=***;Database=***;Uid=***;Pwd=***;" providerName="MySql.Data.MySqlClient"/>
<add name="PersonalWEntities" connectionString="metadata=res://*/EntityData.wellwapsModel.csdl|res://*/EntityData.wellwapsModel.ssdl|res://*/EntityData.wellwapsModel.msl;provider=System.Data.SqlClient;provider connection string="Server=***;Initial Catalog=***;Persist Security Info=False;User ID=***;Password=***;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;;App=EntityFramework""
<add name="PersonalWEntities" connectionString="metadata=res://*/ModelEntity.csdl|res://*/ModelEntity.ssdl|res://*/ModelEntity.msl;provider=System.Data.SqlClient;provider connection string="Server=***;Initial Catalog=***;Persist Security Info=False;User ID=***;Password=***;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;App=EntityFramework""
providerName="System.Data.EntityClient" />
-->
<!--res://*/ModelEntity.csdl|res://*/ModelEntity.ssdl|res://*/ModelEntity.msl;-->
<entityFramework>
<defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework"/>
<providers>
<provider invariantName="MySql.Data.MySqlClient"
type="MySql.Data.MySqlClient.MySqlProviderServices, EntityFramework.MySqlServer"/>
</providers>
</entityFramework>
<!--
<entityFramework>
<defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">
<parameters>
<parameter value="mssqllocaldb"/>
</parameters>
</defaultConnectionFactory>
<providers>
<provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer"/>
</providers>
</entityFramework>
-->
</configuration>
<!--ProjectGuid: F6C222CC-BA5B-494F-826C-DFA5D62E7BAA-->