Me and MySql, MySql Enterprise Library V2

As for my preview post, i need to let work MySql with Enterprise Library in .net 2.0
 
First af all, i downloaded MySQL Connector/Net from http://dev.mysql.com/downloads/connector/net/1.0.html.
 
This is a well done project, that works very well if used alone.
But if you want to use it with Enterprise Library…mmm there are a lot of issue to solve.
First of all, the MySqlConnection, MySqlCommand, etc implements the right interface (IDbConnection, IDbCommand etc), but they dont inherits from DbConnection, DbCommand (and so on) as needed from Enterprise Library.
Second, some classes required from Enterprise Library are missing, like
MySqlClientPermission and MySqlClientPermissionAttribute.
 
After i did the required customization to the library, i’ve implemented the MySql Enterprise Library data layer, and all seems to work well.
 
I’ve done it for MySql 4.1, so it don’t yet use Stored Procedures, but use an exteral file where you can put custom query.
 
My project is open source and you can get it from my workspace

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 :):):)