2026/10/20 -ExecuteReaderAsync returns when the first result is available, not after all rows arrive. Each ReadAsync call advances one row, so the loop processes rows as ...
2026/10/22 -ExecuteReaderAsync ... The following Console application demonstrates how to use two SqlDataReader objects with three SqlCommand objects and a single ...
2025/12/26 -SqlCommand, ExecuteReaderAsync. SqlCommand, ExecuteNonQueryAsync. SqlCommand, ExecuteScalarAsync. SqlDataReader, ReadAsync. SqlDataReader, GetFieldValueAsync.
2026/7/9 -This method is used to fetch the data from the SQL Server database asynchronously and bind the GridView. It uses the OpenAsync and ExecuteReaderAsync methods in ...
2026/6/3 -ExecuteReaderAsync() – executes a query that returns a result set. The method returns a NpgsqlDataReader that can be used to read rows from the query's result ...
2026/10/1 -Convert `SqlServerRepository` methods to use `await conn.OpenAsync()`, `await cmd.ExecuteReaderAsync()`, `await cmd.ExecuteScalarAsync()`. 3. Update ` ...
2026/9/11 -Data.SqlClient, OpenAsync and ExecuteReaderAsync belong to different phases and have different settings. Preserve the complete exception, elapsed time, and ...
2025/12/5 -What is Async Programming? Async means: Do not block the thread. Let long tasks run in background. Free thread to serve other requests.
2026/6/21 -Parameters.AddWithValue("@id", customerId); using var reader = await command.ExecuteReaderAsync(); // Process results ...
2026/6/23 -Write() // → stream.WriteAsync() SqlCommand.ExecuteReader() // → SqlCommand.ExecuteReaderAsync() // Not I/O, but it blocks the thread all the same: Thread.