I'm using MySql server for the BlogEngine.NET back-end. Current version of the BlogEngine.NET supports XML and MS SQL as data storages. But my hosting plan has a limited option for MS SQL databases so i don't want to use it. And XML data provider option saves every post to individual files. Also i have some performance concerns about XML data storages. So i decide to use MySql. It's not very populer in ASP.Net community. But if you give it a chance, you will see how powerful and portable it is. I'm using MySql Connector/Net version 1.0, cause latest version of the connector has some trust level problems on Godaddy. Here are the steps that you need to follow for MySql data provider integration. (I'm assuming you're using BlogEngine.NET 1.2.x.x)
- Create a database and change connection string on the sql.config file.
Download MySql Script (2.43 kb)
<connectionStrings>
<add name="BlogEngine"
connectionString="Server=localhost;
Port=3306;
Database=databasename;
Uid=username;
Pwd='password';"
providerName="MySql.Data.MySqlClient" />
</connectionStrings>
- Add MySql Connector dll to BlogEngine.Core References
Download MySql Connector (54.92 kb)
- Add MYSQLBlogProvider.cs file to Providers folder which on the BlogEngine.Core project. Download MYSQLBlogProvider (4.16 kb)
- Add MySql provider to BlogEngine's provider tag on the web.congfig file.
That's all..You can press F5 and test it ;)