I'd like to use the asp.net Membership and Role stuff and it looks like I need the new connector to accomplish this.  I'm not a seasoned asp.net developer and am BRAND new to the membership stuff.  Do I need the latest connector?  if so, is it supported by ES?

Anyone using Membership and Role services with MySql and ES?
 

We have not downloaded or tested the new MySQL Connector/Net 5.1. A couple of things to note:

It is still in pre-production Release Candidate status.

"Connector/NET 5.1 includes support for MySQL 4.0, MySQL 5.0, MySQL 5.1 and MySQL 6.0 (Falcon Preview) features. Connector/NET 5.1 also includes support for a new membership/role provider, Compact Framework 2.0, a new stored procedure parser and improvements to GetSchema."

While that description does mention membership/role provider support. It also mentions a new stored procedure parser and improvements to GetSchema. My concern is that those things might break MyGeneration's MyMeta support for MySQL. The first thing I would do is make sure I had a copy of the current installer for the Connector in case I needed to revert, download and install connector 5.1, copy MySql.Data.dll to MyGeneration, see if I could establish a connection to a test database, check that the MyMeta Column and Table properties are showing up in MyMeta browser. If I got that far, I would try to run the EntitySpaces StoredProcedure template for MySQL, and see if the generated script would run in my test db.

My suspicion is that MyGeneration's MyMeta would have to be updated for it to work, but, as I say, have not tried it, yet. If anyone does give it a go, we'd be interested in your results, as well.