Unable to Retrieve Metadata

by

It seems that MVC4 Controller scaffolding is not properly recognizing MySql Connection String. Change the connection string as shown below when generating EF CRUD code for Controllers:

<connectionStrings>
    <add name="BTDContext" connectionString="Data Source=host_name;Database=database_name;uid=user_id;pwd=password;" providerName="System.Data.SqlClient" /> 
</connectionStrings>

Change it back to standard when running the application:

<connectionStrings>
    <add name="BTDContext" connectionString="Data Source=host_name;Database=database_name;uid=user_id;pwd=password;" providerName="MySql.Data.MySqlClient" /> 
</connectionStrings>

Note the change, provider name.

More Related Contents:

  1. ASP.NET Identity DbContext confusion
  2. How can I force entity framework to insert identity columns?
  3. How to “warm-up” Entity Framework? When does it get “cold”?
  4. How and where to call Database.EnsureCreated and Database.Migrate?
  5. The type initializer for ‘System.Data.Entity.Internal.AppConfig’ threw an exception
  6. Difference between DropDownlist or DropDownListFor Html helper
  7. Unable to create an object of type ‘[DBContext’s Name]’. For the different patterns supported at design time [closed]
  8. Can an ASP.NET MVC controller return an Image?
  9. MVC3 and Entity Framework
  10. Biggest advantage to using ASP.Net MVC vs web forms
  11. SignalR – Sending a message to a specific user using (IUserIdProvider) *NEW 2.0.0*
  12. Adding ASP.NET MVC5 Identity Authentication to an existing project
  13. Disable Session state per-request in ASP.Net MVC
  14. Generating reset password token does not work in Azure Website
  15. How do I add ROW_NUMBER to a LINQ query or Entity?
  16. Is it possible to access MVC Views located in another project?
  17. Global ASAX – get the server name
  18. Store/assign roles of authenticated users
  19. thread messaging system database schema design
  20. How to Customize ASP.NET Web API AuthorizeAttribute for Unusual Requirements
  21. Using ASP.Net MVC with Classic ADO.Net
  22. Get DisplayName Attribute without using LabelFor Helper in asp.net MVC
  23. ASP.NET Core change EF connection string when user logs in
  24. ASP.net MVC4 WebApi route with file-name in it
  25. ‘System.Net.Http.HttpContent’ does not contain a definition for ‘ReadAsAsync’ and no extension method
  26. Diagnosing 404 errors on IIS 7 and ASP.NET MVC
  27. ASP.NET MVC3 Role and Permission Management -> With Runtime Permission Assignment
  28. I am getting a blank page while deploying MVC application on IIS
  29. Getting the GUID of the current user?
  30. Different users get the same cookie – value in .ASPXANONYMOUS

Leave a Comment