如何将ado.net数据库连接到ASP.Net MVC5

<connectionStrings>
  <add name="MyConnectionString" connectionString="Data Source=YourServer;Initial Catalog=YourDatabase;User ID=YourUsername;Password=YourPassword;" providerName="System.Data.SqlClient" />
</connectionStrings>

<system.web>
  <compilation debug="true" />
</system.web>

using System.Data;
using System.Data.SqlClient;

public class HomeController : Controller
{
    public ActionResult Index()
    {
        string connectionString = ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString;
        
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();
            
            // 执行数据库查询或更新操作
            // 例如：
            SqlCommand command = new SqlCommand("SELECT * FROM Customers", connection);
            SqlDataReader reader = command.ExecuteReader();
            
            // 处理查询结果
            while (reader.Read())
            {
                // 处理每一行数据
            }
            
            // 关闭连接和其他资源
            reader.Close();
        }
        
        return View();
    }
}