How to Connect to MYSQL database in c# MVC website?
<p>I currently run a PHP website which uses MYSQL for the database but now I what to move the website to MVC .Net environment but can't figure out how to this is what I am trying:</p>

<p>I Installed MYSQL.data.Entity, EF, and Web through Nuget package</p>

<p>then I added the connection string in the web.config file: </p>

<pre><code>&lt;connectionStrings&gt;
    &lt;add name="constr" connectionString="Data Source=localhost;Initial Catalog=SampleDB;User Id=root;password=''"/&gt;
&lt;/connectionStrings&gt;
</code></pre>

<p>Password is left empty because there is no password on the database as I running it locally to test it</p>

<p>after all that I still cant view the Database I Server Explorer? should I be able to view the database in server explorer?</p>

<p>How can I make it work?</p>

<p>(also note I took the live database and put it into local)</p>