MonoX support board

Start the conversation, ask questions and share tips and solutions with fellow developers.

Non-registered users can only browse through our support boards. Please register now if you want to post your questions. It takes a second and it is completely free. Alternatively, you can log in without registration using your credentials at major sites such as Google, Microsoft Live, OpenId, Facebook, LinkedIn or Yahoo.

Change the Back End Data Store to MySql  (Mono Support )

Viewed 7510 time(s), 2 post(s) 12/24/2014 11:11:55 AMby NourWaguih
NourWaguih

NourWaguih

12/24/2014 11:11:55 AM
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?
This content has not been rated yet. 
15 Reputation 1 Total posts
khorvat

khorvat

12/24/2014 12:19:18 PM
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
Rated 5.00, 1 vote(s). 
15993 Reputation 2214 Total posts