Will MYSQL work with ASP.NET website?

Question

Can I use MYSQL to connect to ASP.NET website?

What would be advantages and disadvantages of this compared to using MS SQL?

Thanks!

Answer 1

Some main advantages in my opinion to SQL Server aside from support and tooling as Kirk Woll noted is that it scales really really well.

It also comes with a list of features that you might be interested including but hardly limited to

• SQL Server Integration Services which includes ETL and workflow tools
• SQL Server Reporting (which is what you think it is)
• CLR Assembly in side SQL so you can call C# from SQL code.

The major downside to SQL Server is that the licencing can be expensive and oddly a real pain to set it up.