How to connect an ASP.NET application to a MySQL database

Two different methods can be used to connect an ASP.NET application to MySQL database:
 
  - Using ODBC .net data provider
  - Using a MySQL native .NET data provider
 
Both MySQL data connectors are installed on all servers.