Why SQL server used with ASP.NET mostly

Joma Rajab

10y930.NET

I need to find good reason for using sql server database with asp.net which is important for me to demonstrate using it with asp.et and is it the most common use with asp.net or not

I looked at websites but I could not find a good reason as I have to demonstrate why I use it not Mysql

please help

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vinay Singh10y ago
Accepted answer
Region is that we dont need to provide any extra library in Visual studio fopr MS sql server. vs by default have provider for sql. but in case of other data base we need to install the provider and in some senerio it fails
0
Midhun Tp10y ago
Hi,
I had also checked for this answer long time. Despite mysql is an open source database why are we mostly preferring sql for asp.net development. I got the answer as a developer when i used mysql for sometime. I felt sql much more user friendly than mysql and other databases. Also sql and visual studio are microsoft products hence the integration between both of them will be easier compared to others.
You can go through below links for more detailed reasons -
https://www.quora.com/Why-would-a-company-choose-to-use-SQL-Server-over-open-source-databases
http://stackoverflow.com/questions/2557405/what-is-the-reason-large-sites-dont-use-mysql-with-asp-net
0