Intergrating MySql with Enterprise Library for .NET Framework 2.0

Background

Microsoft's Enterprise Library for .NET Framework 2.0 is a framework to base your code around, its flexible and extendable. The Data Access Block proves a database independant implementation layer for you to add into your code, although its database independant, there are only two existing providers supplied with the data access block, SQL Server and Oracle. This article shows you how to add MySql to this list, infact using the ideas from the article it should be possible to implement any .Net database connector as a Data Access Block (well thats the idea...But actually doing it might be quite tricky)

Before we start...

Getting down and dirty...

Start hacking

private DbProviderMapping GetDefaultMapping(string name, string dbProviderName)

if (DbProviderMapping.DefaultMySqlProviderName.Equals(dbProviderName))                
            return defaultMySqlMapping;

   
        private static readonly DbProviderMapping defaultMySqlMapping = new DbProviderMapping(DbProviderMapping.DefaultMySqlProviderName, typeof(MySqlDatabase));
        private IConfigurationSource configurationSource;
        

    public class DatabaseConfigurationView

    {

        private static readonly DbProviderMapping defaultSqlMapping = new DbProviderMapping(DbProviderMapping.DefaultSqlProviderName, typeof(SqlDatabase));

        private static readonly DbProviderMapping defaultOracleMapping = new DbProviderMapping(DbProviderMapping.DefaultOracleProviderName, typeof(OracleDatabase));

        private static readonly DbProviderMapping defaultGenericMapping = new DbProviderMapping(DbProviderMapping.DefaultGenericProviderName, typeof(GenericDatabase));

                private static readonly DbProviderMapping defaultMySqlMapping = new DbProviderMapping(DbProviderMapping.DefaultMySqlProviderName, typeof(MySqlDatabase));

        private IConfigurationSource configurationSource;
        

  
    /// <item>For provider name "System.Data.SqlClient", or for a provider of type <see cref="System.Data.SqlClient"/>, the
    /// <see cref="Microsoft.Practices.EnterpriseLibrary.Data.MySql.MySqlDatabase"/> will be used.</item>
    

        
        /// <summary>
        /// Default name for the MySQL managed provider.
        /// </summary>
        public const string DefaultMySqlProviderName = "MySql.Data.MySqlClient";

        

public const string DefaultOracleProviderName = "System.Data.OracleClient";

Bob's your Uncle

Points of Interest

The Test App

 Database db = DatabaseFactory.CreateDatabase("MySql");

<add name="MySql" connectionString="Data Source=YourServerName;Database=YourDataBase;User ID=YourUserID;Password=YourPassword;"
      providerName="MySql.Data.MySqlClient" />

History