OracleDataAdapter.Fill() requires cursor

[pocketscholar]

I have the latest version of dotConnect for Oracle. When I try to call the OracleDataAdapter.Fill() it doesn't give me the option of not including a Cursor. I don't want to use a cursor. What am I missing?

Code: Select all

Devart.Data.Oracle.OracleConnection orcConn = new Devart.Data.Oracle.OracleConnection(((SemApplication)tabApp).OMSConnectionString)
          Devart.Data.Oracle.OracleDataAdapter da = new Devart.Data.Oracle.OracleDataAdapter();
          da.SelectCommand = new Devart.Data.Oracle.OracleCommand();
          da.SelectCommand.Connection = orcConn;
          da.SelectCommand.CommandText = sql;
          orcConn.Open();
          da.Fill(dt);

[Pinturiccio]

The Fill method of OracleDataAdapter class has overloads that accept a parameter of an OracleCursor type. However, your sample uses an overload that does not accept OracleCursor. For more information, please refer to http://www.devart.com/dotconnect/oracle ... ~Fill.html

When I try to call the OracleDataAdapter.Fill() it doesn't give me the option of not including a Cursor. I don't want to use a cursor. What am I missing?

Please specify where you use a Cursor in your code.

[pocketscholar]

I was missing the Devart.Data reference. All I had was the Devart.Data.Oracle one. When I added Devart.Data my code was okay. I didn't want to use a cursor.