Change the Back End Data Store to MySql

Back to all discussion topics

Mono Support Change the Back End Data Store to MySql

Viewed 17241 time(s), 2 post(s), 12/24/2014 11:11:55 AM - by NourWaguih

NourWaguih

12/24/2014 11:11:55 AM

15 Reputation 1 Total posts

I need to run Mono on Mysql. what is the main changes that i will need to do in the Data access layer project if i am to do so?

1

khorvat

12/24/2014 12:19:18 PM

15993 Reputation 2214 Total posts

Hi,

there are many challenges in order to change the back-end, these are some of the changes from top of my mind

- you need to manually import existing database to MySQL (this will require a lot of schema changes because of the different data types)
- you will need to switch the ASP.NET membership providers (http://dev.mysql.com/doc/connector-net/en/connector-net-programming-asp-provider.html)
- you will need to import and rewrite the ASP.NET membership stored procedures (http://blog.winhost.com/creating-asp-net-membership-tables-in-a-mysql-database/)
- you will need to regenerate the LLBLGen project to use MySQL DataAdapters
- etc.

Regards

2

This is a demo site for MonoX. Please visit Mono Software for more info.