Not an asynchronous query(that just unblocks the calling thread) but an asynchronously *yielding* query
-
Ok..so create a table in SQL Server with a [varchar](50) primary key and insert 500,000 dummy rows into the table. Now, in SSMS, select all rows from that table and you will see results immediately display in the Results window while the query is still running. Opening an ADO.NET connection while awaiting an async reader will allow the thread to continue doing *different* work while the query runs, but I want to yield the results from my data layer to a UI layer as SQL Server prepares and marshals them. Does anyone have any working samples (technology agnostic) or any links they can direct me towards?
"I need build Skynet. Plz send code"
-
Ok..so create a table in SQL Server with a [varchar](50) primary key and insert 500,000 dummy rows into the table. Now, in SSMS, select all rows from that table and you will see results immediately display in the Results window while the query is still running. Opening an ADO.NET connection while awaiting an async reader will allow the thread to continue doing *different* work while the query runs, but I want to yield the results from my data layer to a UI layer as SQL Server prepares and marshals them. Does anyone have any working samples (technology agnostic) or any links they can direct me towards?
"I need build Skynet. Plz send code"