Why is EndExecuteNonQuery () required?

Question

The documentation here states that

developers need the EndExecuteNonQuery method to complete the operation.

I could not find a good reason why this is so, or what results do not cause EndExecuteNonQuery.

Any understanding of what will happen if it is not triggered? I don't want to block it, is there a way to automatically call it in AsyncCallback?

Answer 1

This will do things like:

• update parameter values ​​(exit / return)
• check exceptions (error codes in the TDS stream - restriction of restrictions, etc.)
• /, ..

, :

Answer 2

, , . , EndExecutexxx.

, EndExecuteNonQuery:

 SqlDataReader reader = this.CompleteAsyncExecuteReader();
 if (reader != null)
 {
      reader.Close();
 }