Creating Database Model on ASP.NET MVC with MYSQL

Question

I'm using ASP.NET C# with database MYSQL, I follow this step on creating a database model with Entity Data Model Wizard http://www.asp.net/mvc/tutorials/movie-database/create-a-movie-database-application-in-15-minutes-with-asp-net-mvc-cs. When I run this, it showed error --> Unable to generate the model because of the following exception: 'The provider did not return a ProviderManifestToken string. Access denied for user 'root'@'localhost' (using password: NO).

I already have connection with the same connection string uses on webconfig MySQLMembershp I copied from this How do I setup ASP.NET MVC 2 with MySQL? which is working.

if they have the same connection string uses this should work, but why is not working when I create a database model.

wonde · Accepted Answer · 2012-03-26 02:41:35Z

1

First of all EF model connectionstring and Asp.NET membership connectionstring is different. Secondly you may have to see how EF model works using MySQL database here

Getting MySQL work with Entity Framework 4.0

answered Mar 26, 2012 at 2:41

wonde

6841 gold badge8 silver badges19 bronze badges

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

2 Comments

ThreadRoar Over a year ago

thanks for the reply wonde, yes i know they are different, but there mysqlconnection string are the same. upon looking on the web.i foond this report from mysql <bugs.mysql.com/bug.php?id=61230>. btw ur link is helpful thanks you for this.

thmsn Over a year ago

The link from Mark Yu had the solution for me in a comment:[29 Sep 2011 1:43] Carno Mercado Found the culprit, make sure the connection string should have the "Persist Security Info=True" option. I can now refresh my model from DB, hope this helps others.

junior · Accepted Answer · 2013-05-23 11:38:40Z

0

It seems like you have no password. Have your tried using the password "root"?

answered May 23, 2013 at 11:38

junior

434 bronze badges

Collectives™ on Stack Overflow

Creating Database Model on ASP.NET MVC with MYSQL

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related