Connection String for MySQL, VS2010 Pro, ASP .NET MVC3

Question

Background

I'm following this tutorial, but instead of using SQL Compact, I'd like to use MySQL. I'm having trouble with the connection string needed for this connection.

I've installed MySQL Connector v6.4.4.

I'm now trying to compose the connection string.

Where I'm stuck

I'm trying to create a Controller by right-clicking Controllers > Add Controller. I select the Movie Model and the MovieDBContext Context. I receive an error saying "Unable to retrieve metadata".

Connection strings attempted

I've tried the basic connection string in hopes that Entity would automatically try to use the MySQL connector:
```
Server=localhost;Database=MovieDB;Uid=root;Pwd=pass;
```
I've tried the method used here, and I get another "Unable to retrieve metadata" error.

Is there any way to make this work with MySQL?

xeed · Accepted Answer · 2013-03-29 11:36:06Z

8

The important part is: MySql.Data.MySqlClient

<add name="MovieDBContext"
         connectionString="Server=localhost;Database=MovieDB;Uid=root;Pwd=pass;"
         providerName="MySql.Data.MySqlClient"/>

I know... the question is old, but I tripped over this aswell, so here the answer.

answered Mar 29, 2013 at 11:36

xeed

95710 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2020-06-20 09:12:55Z

3

using MySql.Data.MySqlClient;

string ConnectionString = "database=MovieDB;server=localhost;uid=root;pwd=pass";

MySqlConnection Connection = new MySqlConnection(ConnectionString);

Connection.Open();

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Oct 16, 2011 at 17:00

user997287

1635 bronze badges

1 Comment

SB2055 Over a year ago

Awesome - thank you. Forgive my naivete, but where should I put this?

Collectives™ on Stack Overflow

Connection String for MySQL, VS2010 Pro, ASP .NET MVC3

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related