MVC4, SimpleMemberShip and dotConnect for MySQL

[jmettraux]

Hello,

I'm trying to make the most basic MVC4 project (ASP.NET MVC4 Web Application - "Internet Application") work with dotConnect (7.2.77) and MySQL (5.5) on the latest VisualStudio 2012 (professional).

I've changed the connection string to

<connectionStrings>
<add name="DefaultConnection" connectionString="user id=root;password=root;host=localhost;database=sandbox;persist security info=True" providerName="Devart.Data.MySql" />
</connectionStrings>

which work wells for plain code first / entity framework stuff in other MVC4 projects.

Unfortunately upon trying with SimpleMembership, WebMatrix.WebData.SimpleMembershipProvider.CreateTablesIfNeeded is raising this exception:

https://gist.github.com/3712262

Is there a way to make the vanilla SimpleMembership thing work with DevArt dotConnect? Should I use a different connection string?

Best regards.

[Shalex]

Please refer to http://forums.devart.com/viewtopic.php?f=2&t=24826.