ADO.NET:单个sqlconnection可以一次执行多个查询吗?

有了ADO.NET连接池,运行查询的正确方法是创建和打开连接对象,然后运行命令对象(使用连接对象),然后关闭连接。因此,您描述的场景(将打开的连接传递给两个不同的命令对象)不应该出现。In normal usage your two different command objects should open and close their own connection objects independent of each other, which means you will never run into the problem of two command objects simultaneously attempting to use the same connection at the same time.

也许你应该考虑一下 Multiple Active Result Sets . 您可以对单个sqlconnection对象执行多个查询,尽管有一定的限制。