MySql or MS Sql Server with .Net Application

I'm developing a software using .Net platform. I want to know is it better to use MySql instead of MS Sql Server Express or not? My concern is the DBMS integration with ADO.NET and Entity Framework. Of course I don't want to rewrite the codes which Microsoft has written for integrating MS SQL Server and .Net and also ease of use(I mean wizards and ...) The program has at last 2 or 3 users but it should transfer data to a Server running Linux, Apache and MySql, So if I choose to use MS Sql Server in my application, I shou开发者_C百科ld transfer data between these two DBMSes

Well, your application is quite small (or 2-3 users) and either DB is going to support your load (assuming your not doing anything really wacky and crazy) so its really all up to your preference. Now I wouldn't use SQL server express though, I would spend a little cash and get the full version; using developemnt level stuff for prod is a big no, no.

So in the end it looks like the your question answers itself. Microsoft has built in nice connection between .net and sql server, might as well take advantage of it!

I would use Entity Framework with the mysql provider

there is a question here about it:

Using MySQL with Entity Framework

links to the connector here:

http://www.mysql.com/downloads/connector/net

According to your requirements, I suggest you communicate with MySQL directly instead of MS SQL Server. But in normal circumstances, I would pick MS SQL Server any day, even if it's Express.