Me and MySql, membership providers & Co.

For the CMS i’ve developed in the last year of my free time, i need to use MySql to store ASP.NET 2.0 membership, profiles and roles.
So i begun to work to my MySql providers.
 
First af all, i downloaded MySQL Connector/Net from http://dev.mysql.com/downloads/connector/net/1.0.html.
 
As second step, i look for AccessMembershipProvider (that is now an open source project no more supported in the final .net framework 2.0) and i founded it here : http://msdn.microsoft.com/vstudio/eula.aspx?id=96713a8e-b8d4-4d6e-bb8f-027e6c8e15d8.
It’s based on oledb provider, so for me have been simple to change all oledb reference to MySql provider.
I had some problems :
    First is how MySql server work with Transaction.
    I need to create MySqlTransaction via code rather than using MySqlCommand.
    As second i had to change connection management from FileSystem (as needed for Access) to MySql.
 
In the last step i’ve created all the needed tables importing them from access database using MySql-Front : http://www.mysqlfront.de/
 
So, now, everithing seems to work well with MySql !!!
Yuppy :):):)
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s