Setting up MySQL with ASP.NET MVC 3

Question

I'm currently using Visual Studio 2010 and have created a 'ASP.NET MVC 3 Web Application'.

I've changed the question from SQLite to MySQL for reasons pointed out by Darin.

So I've setup my MySQL database and configured the web.config as shown in this answer, however I get instant configuration error on this:

Parser Error Message: Could not load file or assembly 'MySql.Web, Version=6.2.2.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The system cannot find the file specified.

Line 78: type="MySql.Web.Security.MySQLRoleProvider, MySql.Web

Is this because the public key is wrong?

Thanks

The system cannot find the file specified. Is there something not clear about the error message you would like to ask about? — Darin Dimitrov
– Darin Dimitrov, Commented Mar 4, 2011 at 14:26
But it does exist. I added it as a reference in the project and the only place where it's in the web config are from the stack overflow answer you provided earlier. — ingh.am
– ingh.am, Commented Mar 4, 2011 at 14:29
@ing0: how about some feedback on this? Did you use any suggestions below & what worked for you? — Forer
– Forer, Commented Sep 23, 2011 at 13:49

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

1

You will need to write a custom membership provider which works with SQLite. Here's an example with MySQL. Also notice that SQLite is not intended to be used in a multithreaded environment such as ASP.NET.

edited May 23, 2017 at 9:58

CommunityBot

11 silver badge

answered Mar 4, 2011 at 10:40

Darin Dimitrov

1.0m276 gold badges3.3k silver badges3k bronze badges

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

3 Comments

ingh.am Over a year ago

Thanks, because of the multithreading, would you suggest that I go with MySQL then? I can't use SQLServer annoyingly :(

Darin Dimitrov Over a year ago

Yes, I would suggest you going with some other database.

gideon Over a year ago

@ing0 have a look at sqlce4 blogs.msdn.com/b/sqlservercompact/archive/2011/01/12/…

JuanMa · Accepted Answer · 2011-04-22 16:23:29Z

1

The file is there but versions don't match. Check if you are specifying the correct version for your MySql Connector. This solved the problem for me.

Change Version=6.2.2.0 to the one you are using wherever it applies.

answered Apr 22, 2011 at 16:23

JuanMa

1314 bronze badges

Comments

Richard · Accepted Answer · 2011-03-04 10:43:13Z

0

Try this

<add name="ApplicationServices"
         connectionString="Data Source=|DataDirectory|sqlite.db;Version=3;"
         providerName="System.Data.SqLite" />

If you need sqlite membership provider look here:

http://www.codeproject.com/KB/aspnet/SQLiteProviders.aspx

answered Mar 4, 2011 at 10:43

Richard

22.1k13 gold badges64 silver badges102 bronze badges

Comments

Mike O'Connor · Accepted Answer · 2011-03-19 06:50:51Z

0

What version of the MySQL connector do you have installed? I saw that error message when I had mismatched the version numbers, and it went away when I corrected them. You can check the version by looking at the properties of the item in the references section.

Once that's working, you may also need to add a default membership provider. All you need to do is change <membership> to <membership defaultProvider="MySqlMembershipProvider">.

I also followed the instructions here which added a bunch of tables to the specified database related to membership, profiles, and roles. Not sure if that was required, but something to try if you're still running into issues.

Hope this helps!

edited Mar 19, 2011 at 6:50

answered Mar 19, 2011 at 6:14

Mike O'Connor

3,82327 silver badges27 bronze badges

Collectives™ on Stack Overflow

Setting up MySQL with ASP.NET MVC 3

4 Answers 4

3 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related