MySQL Entity Framework Error – The specified store provider cannot be found in the configuration, or is not valid

by

But it only works on PCs that have had the “MySQL Connector Net 6.4.4” installed.

Does it mean that you are trying to run your code on machine where the provider is not installed? In such case you must also register the provider in your configuration file because installation adds it to machine.config and if you didn’t install it the provider is currently not registered.

Try to add this to your web.config file:

<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, Version=6.4.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />
  </DbProviderFactories>
</system.data>

More Related Contents:

  1. LINQ to SQL multiple tables left outer join
  2. Dynamic MySQL database connection for Entity Framework 6
  3. Error-Attempt by method ‘X.set_DbConnection(System.Data.Common.DbConnection)’ to access method ‘Y.get_Settings()’ failed
  4. How to call Stored Procedures with EntityFramework?
  5. Testing an Entity Framework database connection
  6. Unable to create a constant value of type Only primitive types or enumeration types are supported in this context
  7. Error message ‘Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.’
  8. Entity Framework Timeouts
  9. What difference does .AsNoTracking() make?
  10. What is the purpose of self tracking entities?
  11. LINQ to Entities does not recognize the method ‘Double Parse(System.String)’ method, and this method cannot be translated into a store expression
  12. Configuration System Failed to Initialize
  13. Why is .Contains slow? Most efficient way to get multiple entities by primary key?
  14. Entity Framework/Linq EXpression converting from string to int
  15. Error: “The specified LINQ expression contains references to queries that are associated with different contexts”
  16. The instance of entity type cannot be tracked because another instance of this type with the same key is already being tracked
  17. Creating Composite Key Entity Framework
  18. LINQ to Entities does not recognize the method ‘Int32 Int32(System.String)’ method, and this method cannot be translated into a store expression
  19. linq to entities doesn’t recognize a method
  20. How does Entity Framework work with recursive hierarchies? Include() seems not to work with it
  21. How to convert an expression tree to a partial SQL query?
  22. Generate EF orderby expression by string [duplicate]
  23. Entity Framework Include() is not working
  24. How does LINQ expression syntax work with Include() for eager loading
  25. Optimistic concurrency: IsConcurrencyToken and RowVersion
  26. How do you check if a string contains any strings from a list in Entity Framework?
  27. Calling a SQL User-defined function in a LINQ query
  28. How to pass a table as parameter to MySqlCommand?
  29. How to include() nested child entity in linq
  30. Watch for a table new records in sql database

Leave a Comment