Method of Asyncronous processing in ADO.NET?

Three models in ADO.NET Asynchronous programming:

1. Polling Model

It starts the request and then IsCompleted property when it is done. It is not recommendable as it has tight loop and affects the performance.

2. Callback Model

It uses asyncronous programming technique using AsyncCallback delegate. It needs to create instance of delgate and provide callback interface AsyncResult. AsyncResult, it holds the state of the request when it is completed.

3. Wait Model

It is complex and efficient model. It starts the request and waits until the gets data from sources. It is mostly useful when whn you are connecting multiple datasources.

Follow below links that may help you:

http://www.c-sharpcorner.com/article/asynchronous-data-access-using-callback-model/

https://www.codeproject.com/Tips/1042001/Execute-Long-Running-SQL-Statements-Asynchronously

https://www.codeproject.com/Articles/42266/ADO-NET-Asynchronous-SQL-Calls

https://msdn.microsoft.com/en-us/library/ff664710(v=pandp.50).aspx

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Manas Mohapatra9y ago

Three models in ADO.NET Asynchronous programming:

1. Polling Model

It starts the request and then IsCompleted property when it is done. It is not recommendable as it has tight loop and affects the performance.

2. Callback Model

It uses asyncronous programming technique using AsyncCallback delegate. It needs to create instance of delgate and provide callback interface AsyncResult. AsyncResult, it holds the state of the request when it is completed.

3. Wait Model

It is complex and efficient model. It starts the request and waits until the gets data from sources. It is mostly useful when whn you are connecting multiple datasources.

Follow below links that may help you:

http://www.c-sharpcorner.com/article/asynchronous-data-access-using-callback-model/

https://www.codeproject.com/Tips/1042001/Execute-Long-Running-SQL-Statements-Asynchronously

https://www.codeproject.com/Articles/42266/ADO-NET-Asynchronous-SQL-Calls

https://msdn.microsoft.com/en-us/library/ff664710(v=pandp.50).aspx
0