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-jdbc/2002-11/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).

 

[abbeyro]

On Jan 7, 12:53 pm, "Nicholas Paldino [.NET/C# MVP]"

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.