c# - 使用异步等待在 ForEach 中获取 "The connection does not support MultipleActiveResultSets"

Question

我有以下使用 Dapper.SimpleCRUD 的代码:

var test = new FallEnvironmentalCondition[] {
    new FallEnvironmentalCondition {Id=40,FallId=3,EnvironmentalConditionId=1},
    new FallEnvironmentalCondition {Id=41,FallId=3,EnvironmentalConditionId=2},
    new FallEnvironmentalCondition {Id=42,FallId=3,EnvironmentalConditionId=3}
};
test.ToList().ForEach(async x => await conn.UpdateAsync(x));

使用这段代码，我得到以下异常:

InvalidOperationException: The connection does not support MultipleActiveResultSets

我不明白我正在等待每次更新，所以为什么会出现此错误。

注意:我无法控制连接字符串，因此无法打开 MARS。

Answer 1

您需要在连接字符串中添加属性 MultipleActiveResultSets 并将其设置为 true 以允许多个事件结果集。

 "Data Source=MSSQL1;" & _  
    "Initial Catalog=AdventureWorks;Integrated Security=SSPI;" & _  
    "MultipleActiveResultSets=True"  

阅读更多信息:https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/sql/enabling-multiple-active-result-sets