I tried what's here but it fetched data beyond the timeout I set in seconds.
using (OracleConnection connection = new OracleConnection(connectionString))
{
OracleCommand command = new OracleCommand(selectStatement, connection);
command.Connection.Open();
using (OracleDataAdapter da = new OracleDataAdapter(command))
{
da.SelectCommand.CommandTimeout = 30;
da.Fill(dataTable);
command.Connection.Close();
da.Dispose();
}
}
I tried what's here but it fetched data beyond the timeout I set in seconds.