Setting up .NET MVC3 with MySQL

Question

Hy Guys,

How can I configure the webconfig to access a mysql db using MVC 3?

To use SQLExpress I included this code to configure in an example...

<add name="MovieDBContext"
     connectionString="Server=.\SQLEXPRESS;
     Database=Movies;Trusted_Connection=true"
     providerName="System.Data.SqlClient" />

I'm using Entity Framework.

PS.: I don't want to automatically create tables with the MVC. I want to create them manually.

Thks!

Community · Accepted Answer · 2017-05-23 09:58:25Z

3

Take a look at this post, it seems like your best option is to use MySql Connector with EF

Using MySQL with Entity Framework

your connection string should look something like:

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

edited May 23, 2017 at 9:58

CommunityBot

11 silver badge

answered Feb 3, 2011 at 14:38

Austin M

6041 gold badge5 silver badges19 bronze badges

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

Collectives™ on Stack Overflow

Setting up .NET MVC3 with MySQL

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related