Method of Asyncronous processing in ADO.NET?

Question

What is the poll apporoach  the wait approach and the callback approach in ado.net?

Manas Mohapatra · Answer

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