DbConnection.Open()有效，但dbConnection.OpenAsync()不起作用 [英] DbConnection.Open() works but dbConnection.OpenAsync() doesn't

问题描述

这是一个艰难的过程.使用完全相同的查询字符串，完全相同的以下代码:

This is a tough one. Using the exact same query string, the exact same following code:

using (var db = new SqlConnection(queryString))
{
   await db.OpenAsync();
   var results = await db.ExecuteSomethingAsync...;
   db.Close();
{

从Windows应用程序运行时可以正常工作.但是，当从IIS Express或IIS 7运行时，它将永远卡在await OpenAsync()中.如果我用db.Open()替换该行，则可以正常工作.有什么建议吗?

Will work when ran from a windows application. It will however get stuck forever in await OpenAsync() when ran from IIS Express or IIS 7. If I replace that line with db.Open() it works though. Any suggestions?

推荐答案

正如其他人所提到的，首先确保没有Wait或Result调用您的层次结构. async方法链在依赖于框架的入口点处结束.在UI/WebForms应用程序中，这通常是async void事件处理程序.在WebAPI/MVC应用中，这通常是async操作.

As others have mentioned, first ensure you have no Wait or Result calls up your hierarchy. A chain of async methods ends at an entry point that depends on the framework. In a UI/WebForms app, this is usually an async void event handler. In a WebAPI/MVC app, this is usually an async action.

要检查ASP.NET的其他两件事是:

Two other things to check for ASP.NET are:

• 确保您的目标平台是.NET 4.5.
• 确保已将UseTaskFriendlySynchronizationContext设置为true.

• Ensure your target platform is .NET 4.5.
• Ensure you have UseTaskFriendlySynchronizationContext set to true.

如果需要在多个平台上的共享库中支持async，则可能会找到Microsoft.Bcl.Async NuGet库有帮助.

If you need to support async in a shared library on multiple platforms, you may find the Microsoft.Bcl.Async NuGet library to be helpful.

这篇关于DbConnection.Open()有效，但dbConnection.OpenAsync()不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！