Analogue to ODP's OracleDataReader?

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
bclayshannon
Posts: 29
Joined: Wed 14 Mar 2012 18:37
Location: Monterey, California

Analogue to ODP's OracleDataReader?

Post by bclayshannon » Wed 28 Mar 2012 20:15

I've got this code in a project that was using ODP:

Code: Select all

OracleDataReader odr = cmd.ExecuteReader();
  while (odr.Read()) {
    ACurrentUserRoles.Add(odr.GetString(0));
}
What is the corresponding class to OracleDataReader that I can use with DotConnect?

bclayshannon
Posts: 29
Joined: Wed 14 Mar 2012 18:37
Location: Monterey, California

A start?

Post by bclayshannon » Wed 28 Mar 2012 20:59

Does this make sense:

Code: Select all

cmd.Parameters.Add("cur", OracleDbType.Cursor);
cmd.Parameters["cur"].Direction = ParameterDirection.Output;
OracleCursor oraCursor = (OracleCursor)cmd.Parameters["cur"].Value;
Devart.Data.Oracle.OracleDataReader odr = cmd.ExecuteReader();

while (odr.Read()) 
{
  ACurrentUserRoles.Add(odr.GetString(0));
}
(cmd is a Devart.Data.Oracle.OracleCommand)

?

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Post by Pinturiccio » Fri 30 Mar 2012 08:42

bclayshannon wrote:What is the corresponding class to OracleDataReader that I can use with DotConnect?
dotConnect for Oracle uses the same class name - OracleDataReader. For more information, please refer to http://www.devart.com/dotconnect/oracle ... eader.html
bclayshannon wrote:Does this make sense
We have answered you at our forum http://www.devart.com/forums/viewtopic.php?t=23766

Post Reply