Using mySql data in an ASP.NET application

Question

I am new to ASP and would like to experiment with it by writing a club website for my school using .net 2008 and the mySql database, available on the Apache server. What is the best way to install this, since I see many options for connecting a web application to SQL Server or Oracle databases, but I'm nervous that it will not work correctly with mySql.

Also, can I still use LINQ queries?

Answer 1

Free the MySQL Connector for ASP.NET and start coding as usual for MySQL. The connector gives you all the benefits of data adapters, data readers, etc. in the typical ADO.NET framework you're used to for SQL or Oracle. Thus, if in the future you change places at the back end, you do not have to worry about replacing all of your connection / request code.

Answer 2

Check this URL: http://dev.mysql.com/tech-resources/articles/dotnet/index.html