CaseSensitive list of tables from C#

[abbeyro]

Hello,

I'm trying to retrieve a list of tables from all_tables in a given
Oracle db. I'm using System.Data.OracleClient, OracleCommand and
OracleDataReader and I always obtain the results in uppercase. The
problem is that some tables where defined in "Mixed/Case" so when I
retrieve the list I need to obtain the exact case used when they were
created. Is there any option I need to specify in the connection or
the data provider to achieve this? From the SQL command line I do get
the right case, the problem happens only from C#. Any advice is
welcome.

Thank-you.
Abbeyro

[Nicholas Paldino [.NET/C# MVP]]

Abbeyro,

ALL_TABLES seems to store the table name in upper case (as do most
dictionary views in Oracle):

http://www.suite101.com/article.cfm/oracle/115853/2

http://archives.postgresql.org/pgsql...1/msg00146.php

Although the second link seems to suggest that if you quote the table
name upon creation, it will retain the table name (you should test this out
first).
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

<ab*****@gmail.comwrote in message
news:0a**********************************@z17g2000 hsg.googlegroups.com...

Hello,

I'm trying to retrieve a list of tables from all_tables in a given
Oracle db. I'm using System.Data.OracleClient, OracleCommand and
OracleDataReader and I always obtain the results in uppercase. The
problem is that some tables where defined in "Mixed/Case" so when I
retrieve the list I need to obtain the exact case used when they were
created. Is there any option I need to specify in the connection or
the data provider to achieve this? From the SQL command line I do get
the right case, the problem happens only from C#. Any advice is
welcome.

Thank-you.
Abbeyro

[abbeyro]

On Jan 7, 12:53 pm, "Nicholas Paldino [.NET/C# MVP]"
<[e-mail]:
Although the second link seems to suggest that if you quote the table

name upon creation, it will retain the table name (you should test this out
first).

Thanks for your reply Nicholas. I already verified that all_tables
actually returns the proper case, by using Oracle's command line.
The issue therefore seems to be with the Microsoft adapter that
returns everything uppercase.

Created as: "my/table"
From shell: my/table
From .NET: MY/TABLE

Is there any way to specify that this shouldn't be the correct
behavior?

Thank-you in advance.