If all you need to do is *integrate* with a MySQL database, you can of course use a suitable .NET MySQL connector:

http://dev.mysql.com/downloads/connector/net/6.8.html

To access the MySQL database from a module, you'll need a suitable entry in your web.config e.g.

<add name="MySqlDataProvider" 
    type="MySql.Data.MySqlDataProvider, MySql.MySqlDataProvider" 
    connectionStringName="SiteMySqlServer" 
    upgradeConnectionString=""
    providerPath="~\Providers\DataProviders\MySqlDataProvider\" 
    objectQualifier="" 
    databaseOwner="root" 
/>

It's easy enough to then create your concrete SQLDataProvider.

Add a reference to MySql.Data:

using MySql.Data.MySqlClient;

Here's how you'd get your connection string:

_connectionString = Config.GetConnectionString("SiteMySqlServer");

And here's an example of calling a DB-specific helper method from your concrete class:

return (IDataReader)MySqlHelper.ExecuteReader(ConnectionString, "SELECT * FROM Expense;");

Compare this with the MS SQL Server version:

return (IDataReader)SqlHelper.ExecuteReader(ConnectionString, CommandType.Text, "SELECT * FROM Expense;");

Kuldeep,
sorry, DNN 7 (as well as previous versions and DNN 8) are optimized for Microsoft SQL Server.
There are plans to use Entity Framework for DNN neXt, which would support other DBMS as well.

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN