IO Completion Ports (IOCP)

Yakov Published at Dev

Yakov

When I call BeginExecuteReader (SQL) does it use IO Completion Ports? What makes it to be asynchronous? Should I call it from Begin[Operation]() or from the wrapper for IAsyncResult constructor?

Richard

does it use IO Completion Ports

Maybe, but that's an implementation detail deep in the native SQL Client's implementation.

Remember the SQL Server ADO.NET calls into the (local) native SQL Server client which will perform communication with the server.

What makes it to be async?

Its implementation. There is more than one way to do this, from approaches which fake it (perform blocking operations with a dedicated worker thread) through to IO Completion Ports and other "true" asynchronous APIs.

Where from should I call it ?

Wherever is right for your design.

for IAsyncResult constructor?

How you use the asynchronous APIs (callback passed to BeginExecuteReader, poll the returned IAsyncResult's IsComplete, wait on IAsyncResult, convert to a Task with TaskFactory.FromAsync, using the Reactive Extensions with Observable.FromAsyncPattern, or something else) is again part of the design of your code.

There are too many possibilities to give any form of guidance.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-02-6

Comments

0 comments

From Dev

Related Related

Article

IO Completion Ports (IOCP)

IO Completion Ports (IOCP)

IO Completion Ports and socket send()

IO Completion Ports and socket WSARecv()

IO Completion Ports and OVERLAPPED management

IO Completion Ports and socket send()

IO Completion Ports and socket WSARecv()

Asynchronous action methods and IO completion ports

How to reregister for IO Completion ports for a handle

io completion ports issue with calling multiple wsarecv or wsasend per GetQueuedCompletionStatus

IOCP AcceptEx not creating completion upon connect

Multiple I/O Completion Ports

select() equivalence in I/O Completion Ports

AVR IO Ports can not be global

IO Completion port Linux equivalent

Business logic in IO completion Port

IO Completion port Linux equivalent

IOCP: If operation returns immediately with error, can I still receive completion notification?

How does the operating system post io completion messages for async io

How does the operating system post io completion messages for async io

ASIO IO completion callbacks order vs the order of actual IO operations

I/O Completion Ports *LAST* called callback, or: where it's safe to cleanup things

C# How to perform Asynchrounus I/O using Completion Ports with APM-TAP Patterns on WCF Callback?

pandas from mac ports ImportError: No module named io.data

Visual c++ 2005 'Ports' : is not a member of 'System::IO'

Using system.io.ports c# Windows IoT Univeral

IOCP threads - Clarification?

Using IOCP with send() and recv()

Should WSASocket() be used with IOCP?

IOCP recv AND send

Should WSASocket() be used with IOCP?

I/O Completion Ports LAST called callback, or: where it's safe to cleanup things