How replace OracleDataTable to DbDataTable?

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for universal data access
Post Reply
AKRRKA
Posts: 198
Joined: Thu 26 Jan 2012 15:07
Location: Russia
Contact:

How replace OracleDataTable to DbDataTable?

Post by AKRRKA » Tue 11 Dec 2012 14:16

How i can replace Devart.Data.Oracle.OracleDataTable to Devart.Common.DbDataTable or other DataTable from dotConnect Universal Professional?

Samlpe:

Code: Select all

const string sqlString = "SELECT * FROM JOINS";

var myDataTable = new OracleDataTable(sqlString, oConnection) { Active = true };

myDataTable.Fill();
After change oConnection from Devart.Data.Oracle.OracleConnection to Devart.Data.Universal.UniConnection all ok.
But how change OracleDataTable?

PS: Devart.Common.DbDataTable is abstract class!!!

PPS: Attention! Into help http://www.devart.com/dotconnect/univer ... Table.html link is incorrect this
For more information on advanced features of DbDataTable please refer to topic DataTable Advanced Features.
Show only
The resource you are looking for has been removed, had its name changed, or is temporarily unavailable.

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

Re: How replace OracleDataTable to DbDataTable?

Post by Pinturiccio » Thu 13 Dec 2012 15:10

The Professional Edition of dotConnect Universal includes the Standard Edition of dotConnect for Oracle.
OracleDataTable is available only in the Professional Edition of dotConnect for Oracle, so dotConnect Universal doesn't have an analog for OracleDataTable.

You can use the System.Data.DataTable class. Then you can fill and update the System.Data.DataTable object with UniDataAdapter. For more information, please refer to http://www.devart.com/dotconnect/univer ... apter.html

AKRRKA
Posts: 198
Joined: Thu 26 Jan 2012 15:07
Location: Russia
Contact:

Re: How replace OracleDataTable to DbDataTable?

Post by AKRRKA » Fri 14 Dec 2012 07:43

The dotConnect Universal Professional includes:
UniConnection, UniCommand, UniDataReader, UniDataAdapter, UniTransaction, UniParameter, UniException, UniCommandBuilder, UniConnectionStringBuilder, UniMonitor, UniProvider, UniScript
why do you not realize UniDataTable?

For a start, we used in trial mode Devart.Data.Oratsle, but when the application was ready decided to buy all the same generic component dotConnect Universal Professional. Now we need to replace one another in the code.

Please help to do this. Posted in support but no response from them so never received.

PS:We already have done so with UniDataAdapter, but it's not nice out, I would still like something UniDataTable.

PPS:I also wrote that in the online help does not work link (see first post).

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

Re: How replace OracleDataTable to DbDataTable?

Post by Pinturiccio » Fri 14 Dec 2012 14:25

OracleDataTable is an additional feature that was implemented in dotConnect for Oracle. We are not planning to implement the similar feature, let's call it UniDataTable, in dotConnect Universal.
AKRRKA wrote:PPS:I also wrote that in the online help does not work link (see first post).
Thanks for the reminder, we'll fix our documentation.

Post Reply