OracleDataAdapter and MissingSchemaAction

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
chamamo
Posts: 3
Joined: Tue 10 Jul 2012 16:33

OracleDataAdapter and MissingSchemaAction

Post by chamamo » Tue 21 May 2013 13:59

Hi,

I have Oracle Database, and one table with 2 columns (col1, col2);
In my solution I have a DataTable to represente the table, but it have just the first colomn (col1).

Code: Select all

var cmd = new OracleCommande();
cmd.CommandText = "SELECT * FROM MyTable";
cmd.Connection = new OracleConnection(MyConnectionString);

var dta = new OracleDataAdapter();
dta.SelectCommand = cmd;
dta.MissingSchemaAction = MissingSchemaAction.Ignore;
dta.Fill(dataTable);
I changed the MissingSchemaAction to MissingSchemaAction .Ignore to ignore the second colomn, but the adapter add it, have you a solution to my problem?

thank you in advance.

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

Re: OracleDataAdapter and MissingSchemaAction

Post by Pinturiccio » Thu 23 May 2013 13:35

We have reproduced the issue. We will investigate it and notify you about the results as soon as possible.

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

Re: OracleDataAdapter and MissingSchemaAction

Post by Pinturiccio » Tue 02 Jul 2013 13:55

We have fixed the bug with the malfunctioning MissingSchemaAction property of OracleDataAdapter. We will post here when the corresponding build of dotConnect for Oracle is available for download.

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

Re: OracleDataAdapter and MissingSchemaAction

Post by Pinturiccio » Wed 03 Jul 2013 11:55

The new build of dotConnect for Oracle 7.7.276 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?t=27462

Post Reply