Im working on a team project which was created in Visual Studio MVC with MySql. When testing everything locally it was fine. When i was ready to go live, i deployed the app through GitHub, everything went good, but just no data.
I was using a local connection string with user=root and password=password to MySql Workbench in VS Web.Config.
I have created a new connection on MySql to Azure server with username and password supplied, Connection tested fine.
I changed the connection string in web config to Azures server name , username and password(Not quite sure about the ConnString Alias though).
I commited these changes, but still nothing. I am a bit confused about the process to be honest. Not quite sure how to move the existing local database model over to Azure.
Having Set up a linked ClearDb to my web app site, i made changes to the web config:
<add name="MTEntities" connectionString="metadata=res://*/MechanicEntities.csdl|res://*/MechanicEntities.ssdl|res://*/MechanicEntities.msl;provider=MySql.Data.MySqlClient;provider connection string="server=(AZURE SERVER ADDRESS);user id=AZUREID;password=AZURESERVERPASSWORD;database=CLEARDB_LINKED_DATABASE_NAME;" providerName="MySql.Data.MySqlClient" />
Should i make changes to this
<entityFramework>
<defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">
<parameters>
<parameter value="v11.0" />
</parameters>
</defaultConnectionFactory>
I know these settings should be changed, i have tried a few things but to no avail, one method was
here on Stackoverflow.