title: Error 175: The ADO.NET provider with invariant name 'MySql.Data.MySqlClient' is either not registered in the machine or application config file
body: <p>One of my clients gave me a VS2015 solution file which I am supposed to work on. However, I am unable to compile it. I am using VS2015 as well.</p>
  
  <p>It uses Entity Framework, which I do not know much about.</p>
  
  <p>The error given is : Error 175: The ADO.NET provider with invariant name 'MySql.Data.MySqlClient' is either not registered in the machine or application config file, or could not be loaded. See the inner exception for details.  </p>
  
  <p>The error points to an an EDMX File which is as follows:</p>
  
  <p>I do not know where to start or how to resolve this. Any help? Thanks</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="utf-8"?&gt;
  &lt;edmx:Edmx Version="3.0" xmlns:edmx="http://schemas.microsoft.com/ado/2009/11/edmx"&gt;
    &lt;!-- EF Runtime content --&gt;
    &lt;edmx:Runtime&gt;
      &lt;!-- SSDL content --&gt;
      &lt;edmx:StorageModels&gt;
        &lt;Schema Namespace="NFMTestModel.Store" Provider="MySql.Data.MySqlClient" ProviderManifestToken="5.7" Alias="Self" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl"&gt;
          &lt;!--Errors Found During Generation:
  warning 6002: The table/view 'def.nfm.air' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.--&gt;
          &lt;EntityType Name="air"&gt;
            &lt;Key&gt;
              &lt;PropertyRef Name="DateAndTime" /&gt;
            &lt;/Key&gt;
            &lt;Property Name="DateAndTime" Type="datetime" Precision="0" Nullable="false" /&gt;
            &lt;Property Name="Air_System_Air_line_1_Service_Pressure_Value" Type="double" /&gt;
            &lt;Property Name="Air_System_Air_line_2_emergency_Pressure_Value" Type="double" /&gt;
            &lt;Property Name="Air_System_Air_Manlock_point_11_Pressure_Value" Type="double" /&gt;
            &lt;Property Name="Air_System_Air_Manlock_point_12_Pressure_Value" Type="double" /&gt;
            &lt;Property Name="Air_System_Air_Manlock_point_21_Pressure_Value" Type="double" /&gt;
            &lt;Property Name="Air_System_Air_Manlock_point_22_Pressure_Value" Type="double" /&gt;
            &lt;Property Name="Air_System_Air_Manlock_regulation_Pressure_Value" Type="double" /&gt;
            &lt;Property Name="Air_System_Air_System_Pressure_Value" Type="double" /&gt;
          &lt;/EntityType&gt;
          &lt;!--Errors Found During Generation:
  warning 6002: The table/view 'def.nfm.articulation' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.--&gt;
          &lt;EntityType Name="articulation"&gt;
            &lt;Key&gt;
              &lt;PropertyRef Name="DateAndTime" /&gt;
            &lt;/Key&gt;
            &lt;Property Name="DateAndTime" Type="datetime" Precision="0" Nullable="false" /&gt;
            &lt;Property Name="Articulation_Angle_Horizontal_Value" Type="double" /&gt;
            &lt;Property Name="Articulation_Angle_Vertical_Value" Type="double" /&gt;
            &lt;Property Name="Articulation_Force_Value" Type="double" /&gt;
            &lt;Property Name="Articulation_Pushing_in_X_Value" Type="double" /&gt;
            &lt;Property Name="Articulation_Pushing_in_Y_Value" Type="double" /&gt;
            &lt;Property Name="Articulation_Speed_Value" Type="double" /&gt;
            &lt;Property Name="Articulation_Bottom_Side_Delta_Pressure_Value" Type="double" /&gt;
            &lt;Property Name="Articulation_Bottom_Side_Elongation_LH_Value" Type="double" /&gt;
            &lt;Property Name="Articulation_Bottom_Side_Elongation_RH_Value" Type="double" /&gt;
            &lt;Property Name="Articulation_Bottom_Side_Elongation_Setpoint_Value" Type="double" /&gt;
            &lt;Property Name="Articulation_Bottom_Side_Elongation_Start_point_Value" Type="double" /&gt;
            &lt;Property Name="Articulation_Bottom_Side_Elongation_Virtual_Value" Type="double" /&gt;
            &lt;Property Name="Articulation_Bottom_Side_Extend_Pressure_Value" Type="double" /&gt;
            &lt;Property Name="Articulation_Bottom_Side_Force_Value" Type="double" /&gt;
            &lt;Property Name="Articulation_Bottom_Side_High_Limit_Value" Type="double" /&gt;
            &lt;Property Name="Articulation_Bottom_Side_Low_Limit_Value" Type="double" /&gt;
            &lt;Property Name="Articulation_Bottom_Side_Retract_Pressure_Value" Type="double" /&gt;
  </code></pre>