ExecuteReaderAsync
Overload List:
This method returns a Task-based asynchronous version of OracleCommand.ExecuteReader()
, which fetches the result set as an OracleDataReader
object.
-
This method returns a Task-based asynchronous version of
OracleCommand.ExecuteReader()
, which fetches the result set as anOracleDataReader
object. -
ExecuteReaderAsync(CancellationToken cancellationToken)
This method returns a Task-based asynchronous version of
OracleCommand.ExecuteReader()
, which fetches the result set as anOracleDataReader
object. -
ExecuteReaderAsync(CommandBehavior behavior)
This method returns a Task-based asynchronous version of
OracleCommand.ExecuteReader()
, which fetches the result set as anOracleDataReader
object. -
ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
This method returns a Task-based asynchronous version of
OracleCommand.ExecuteReader()
, which fetches the result set as anOracleDataReader
object.
Example (Using all overloads)
using Oracle.ManagedDataAccess.Client; using System; using System.Data; using System.Threading; namespace AsyncApp { class AsyncDemo { static async Task Main() { string connectionString = "User Id=HR; Password=<PASSWORD>; Data Source=oracle;"; OracleConnection oc = new OracleConnection(connectionString); await oc.OpenAsync(CancellationToken.None); OracleCommand cmd = oc.CreateCommand(); cmd.CommandText = "select * from demo_table"; OracleDataReader reader; reader = await cmd.ExecuteReaderAsync(); while (await reader.ReadAsync(CancellationToken.None)) { Console.WriteLine(reader.GetValue(0)); } reader = await cmd.ExecuteReaderAsync(CancellationToken.None); while (await reader.ReadAsync(CancellationToken.None)) { Console.WriteLine(reader.GetValue(0)); } reader = await cmd.ExecuteReaderAsync(CommandBehavior.Default); while (await reader.ReadAsync(CancellationToken.None)) { Console.WriteLine(reader.GetValue(0)); } reader = await cmd.ExecuteReaderAsync(CommandBehavior.Default, CancellationToken.None); while (await reader.ReadAsync(CancellationToken.None)) { Console.WriteLine(reader.GetValue(0)); } } } }