如何在ASP.NET C#中执行多个数据库请求？

using System.Data.SqlClient;

string connectionString = "Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=True";

using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();

    using (SqlCommand command1 = new SqlCommand("SELECT * FROM Table1", connection))
    {
        using (SqlDataReader reader1 = command1.ExecuteReader())
        {
            while (reader1.Read())
            {
                // 处理查询结果
            }
        }
    }

    using (SqlCommand command2 = new SqlCommand("SELECT * FROM Table2", connection))
    {
        using (SqlDataReader reader2 = command2.ExecuteReader())
        {
            while (reader2.Read())
            {
                // 处理查询结果
            }
        }
    }
}

using System.Data.Entity;

public class MyDbContext : DbContext
{
    public MyDbContext() : base("name=MyConnectionString")
    {
    }

    public DbSet<Table1> Table1 { get; set; }
    public DbSet<Table2> Table2 { get; set; }
}

using (MyDbContext context = new MyDbContext())
{
    // 执行第一个查询
    var query1 = from t1 in context.Table1
                 select t1;

    // 执行第二个查询
    var query2 = from t2 in context.Table2
                 select t2;

    // 执行查询并保存更改
    context.SaveChanges();
}