Azure ASP MVC Entity Framework App, with MySql, Cant connect

See more:

C#

ASP.NET

MVC

Azure

Git

, +

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.