MySql Data Provider

This version of the Enterprise Library MySQL Data Provider was tested against the MySQL Database v5.1.34
and uses the MySQL data provider v6.0.3 downloaded separately.

The MySQL database, client tools and .NET data provider can all be downloaded from http://dev.mysql.com/downloads and are licence free.

The following is an example of a configuration file using a MySQL Data Provider:

[XML]
<?xml version="1.0" encoding="utf-8"?>
<configuration>
	<configSections>
		<section name="dataConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data, Version=4.1.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
	</configSections>
	<dataConfiguration defaultDatabase="Service_Dflt">
		<providerMappings>
			<add databaseType="EntLibContrib.Data.MySql.MySqlDatabase, EntLibContrib.Data.MySql, Version=4.1.0.0, Culture=neutral, PublicKeyToken=null" name="MySql.Data.MySqlClient" />
		</providerMappings>
	</dataConfiguration>
	<connectionStrings>
		<add	name="Service_Dflt"
			providerName="MySql.Data.MySqlClient"
			connectionString="database=northwind;uid=root;" />
		<add	name="NewDatabase"
			providerName="MySql.Data.MySqlClient"
			connectionString="database=northwind;uid=root;charset=utf8;"/>
		<add	name="DbWithMySQLAuthn"
			providerName="MySql.Data.MySqlClient"
			connectionString="database=northwind;uid=entlib;pwd=********"/>
		<add	name="NwindPersistFalse"
			providerName="MySql.Data.MySqlClient"
			connectionString="database=northwind;uid=entlib;pwd=********;Persist Security Info=false"/>
	</connectionStrings>
</configuration>