Have Geek Brain

Asp.net with mysql

I know asp.net with mySQL is possible, but does it work well (fast and stable)? I am looking at a project for a client, they want to stay on mySQL, but they like the idea of ​​migrating to asp.net from PHP. I can give them the best price on the market in asp.net (more productive for me) and keep the project within my budget.

BUT , will I be running a lot of "gotchas" related to my mySQL database instead of the SQl Server database I'm used to?

Seek advice from people who have actually done projects using the two together ... either successfully or unsuccessfully.

+1


a source to share


3 answers


Seriously man, I wouldn't try to complicate it. Write the site the same as usual, but using the MySQL data provider instead of the mssql provider. Keep it simple. Now there are some differences in how the two DBMSs handle their SQL.

Here are the items that initially turned me off.

MSSQL: SELECT TOP 5 * FROM Table MySQL: SELECT * FROM TABLE LIMIT 0.5

MSSQL: SELECT IsNull (NumberField, 0) FROM Table MySQL: SELECT IfNull (NumberField, 0) FROM TABLE



MySQL: Everything is CaSe-SenSiTivE MySQL: Stores procedures, but they are not as user friendly as MSSQL, so stick with the inline sql.

MSSQL: select * from table where column1 = @ col1 and column2 = @ col2 MySQL: select * from table where column1 =? and column2 =? (don't forget to include your command options in order)

There are tons of other little things that can complicate or confuse, but what is this site for, so you might ask

+1


a source


There is a third option, MSSQL ↔ SSIS / DTS ↔ MySQL.



Both sides can stay in their comfort zones and you'll be more productive rather than tearing the hair running around gotchas.

0


a source


I would suggest using a tool like iBATIS.NET. It is a data mapping tool that works very well with .NET and is very easy to learn and customize.

You can set up multiple database providers (MySQL, SQL Server, Oracle, Sybase, etc.); almost everything is set to XML, so the SQL can be edited while your application is running, and if at some point they want to switch the backend databases, it's (sometimes) as easy as changing a couple of settings in the XML file.

Check it out: http://ibatis.apache.org/overview.html

0


a source






More articles:


All Articles