Intergrating MySql with Enterprise Library for .NET Framework 2.0

Mark Pryce-Maher

Rate me:

3.73/5 (12 votes)

7 May 2007CPOL4 min read

125.7K

2.5K

An article on adding a MySql connector into Enterprise Library for .NET Framework 2.0

mysql_src.zip
mysqldemo_src.zip
- mysqldemo
  - App.config
  - bin
    - Debug
      - Microsoft.Practices.EnterpriseLibrary.Common.dll
      - Microsoft.Practices.EnterpriseLibrary.Common.xml
      - Microsoft.Practices.EnterpriseLibrary.Data.dll
      - Microsoft.Practices.EnterpriseLibrary.Data.xml
      - Microsoft.Practices.ObjectBuilder.dll
      - Microsoft.Practices.ObjectBuilder.xml
      - MySql.Data.dll
      - mysqldemo.exe
      - mysqldemo.exe.config
      - mysqldemo.vshost.exe
      - mysqldemo.vshost.exe.config
  - Form1.cs
  - Form1.Designer.cs
  - Form1.resx
  - mysqldemo.csproj
  - Program.cs
  - Properties
data.zip
- Data
  - bin
    - Debug
  - CachingMechanism.cs
  - Configuration
    - DatabaseAssemblerAttribute.cs
    - DatabaseSettings.cs
    - DbProviderMapping.cs
    - Design
      - AddConnectionStringSettingsNodeCommand.cs
      - AddConnectionStringsSectionNodeCommand.cs
      - AddDatabaseSectionNodeCommand.cs
      - AddOracleConnectionElementNodeCommand.cs
      - bin
        
        Debug
        
        Microsoft.Practices.EnterpriseLibrary.Common.dll
        
        Microsoft.Practices.EnterpriseLibrary.Common.xml
        
        Microsoft.Practices.EnterpriseLibrary.Configuration.Design.dll
        
        Microsoft.Practices.EnterpriseLibrary.Configuration.Design.xml
        
        Microsoft.Practices.EnterpriseLibrary.Data.Configuration.Design.dll
        
        Microsoft.Practices.EnterpriseLibrary.Data.Configuration.Design.XML
        
        Microsoft.Practices.EnterpriseLibrary.Data.dll
        
        Microsoft.Practices.EnterpriseLibrary.Data.xml
        
        Microsoft.Practices.ObjectBuilder.dll
        
        MySql.Data.dll
      - ConnectionStringParser.cs
      - ConnectionStringsCommandRegistrar.cs
      - ConnectionStringsConfigurationDesignManager.cs
      - ConnectionStringSettingsNode.bmp
      - ConnectionStringSettingsNode.cs
      - ConnectionStringsSectionBuilder.cs
      - ConnectionStringsSectionNode.bmp
      - ConnectionStringsSectionNode.cs
      - ConnectionStringsSectionNodeBuilder.cs
      - Data.Configuration.Design.csproj
      - Data.Configuration.Design.csproj.vspscc
      - DatabaseSectionBuilder.cs
      - DatabaseSectionNode.bmp
      - DatabaseSectionNode.cs
      - DatabaseSectionNodeBuilder.cs
      - DataCommandRegistrar.cs
      - DataConfigurationDesignManager.cs
      - IDatabaseProviderName.cs
      - OracleConnectionCommandRegistrar.cs
      - OracleConnectionConfigurationDesignManager.cs
      - OracleConnectionElementNode.bmp
      - OracleConnectionElementNode.cs
      - OracleConnectionElementNodeBuilder.cs
      - OracleConnectionSettingsBuilder.cs
      - OraclePackageElementNode.bmp
      - OraclePackageElementNode.cs
      - ParameterNode.bmp
      - ParameterNode.cs
      - Properties
        
        AssemblyInfo.cs
        
        Resources.Designer.cs
        
        Resources.resx
      - ProviderEditor.cs
      - ProviderEditorUI.cs
      - ProviderEditorUI.resx
      - ProviderMappingNode.bmp
      - ProviderMappingNode.cs
      - ProviderMappingsNode.bmp
      - ProviderMappingsNode.cs
    - IDatabaseAssembler.cs
  - ConnectionString.cs
  - Data.csproj
  - Data.csproj.vspscc
  - Database.cs
  - DatabaseConfigurationView.cs
  - DatabaseCustomFactory.cs
  - DatabaseFactory.cs
  - DatabaseMapper.cs
  - DatabaseProviderFactory.cs
  - GenericDatabase.cs
  - GenericDatabaseAssembler.cs
  - Instrumentation
    - CommandExecutedEventArgs.cs
    - CommandFailedEvent.cs
    - CommandFailedEventArgs.cs
    - ConnectionFailedEvent.cs
    - ConnectionFailedEventArgs.cs
    - DataConfigurationFailureEvent.cs
    - DataEvent.cs
    - DataInstrumentationInstaller.cs
    - DataInstrumentationInstaller.Designer.cs
    - DataInstrumentationListener.cs
    - DataInstrumentationListenerBuilder.cs
    - DataInstrumentationProvider.cs
    - DefaultDataEventLogger.cs
    - DefaultDataEventLoggerCustomFactory.cs
  - mySql
    - MySqlDatabase.cs
    - MySqlDatabaseAssembler.cs
  - Oracle
    - Configuration
    - IOraclePackage.cs
    - OracleDatabase.cs
    - OracleDatabaseAssembler.cs
    - OracleDataReaderWrapper.cs
  - ParameterCache.cs
  - Properties
    - AssemblyInfo.cs
    - Resources.Designer.cs
    - Resources.resx
  - Sql
    - SqlDatabase.cs
    - SqlDatabaseAssembler.cs
  - UpdateBehavior.cs

<configuration>
  <configSections>
    <section name="dataConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null" />
  </configSections>
  <dataConfiguration defaultDatabase="DataAccessQuickStart" />
  <connectionStrings>
      <add name="MySql" connectionString="Data Source=tcg22198z;Database=pttrading;User ID=root;Password=c0ntr0l;"
      providerName="MySql.Data.MySqlClient" />
  </connectionStrings>
</configuration>

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Mark Pryce-Maher

Web Developer

United Kingdom

I've been a programmer for longer than I care to remember. It all started with those BBC (model B's) at school, it all went down hill from there.....

This year, I am mostly coding in.. C# (WPF & WCF)

Blog Address http://markpm.blogspot.com

Intergrating MySql with Enterprise Library for .NET Framework 2.0

License

Comments and Discussions