Typed DataSet with Oracle

  • Thread starter Thread starter mail747097
  • Start date Start date
M

mail747097

I'm developing an application that accesses an Oracle database. If I
add a typed DataSet to my application and drag/drop a table in Oracle
from Solution Explorer all integer column in the table becomes
System.Decimal columns in the DataSet. I'm using Visual Studio 2005
and System.Data.OracleClient to access Oracle.
 
This is due to the way Oracle treats numbers. You can repurpose the columns,
if you would like, but realize you will have to translate, if you do. For
many cases, having an input check and converting to go back to the database,
is enough.

If you want more precision, you can move to the Oracle ODP.NET, but realize
this will not be drag and drop.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com

********************************************
Think outside the box!
********************************************
 
This is due to the way Oracle treats numbers. You can repurpose the columns,
if you would like, but realize you will have to translate, if you do. For
many cases, having an input check and converting to go back to the database,
is enough.

If you want more precision, you can move to the Oracle ODP.NET, but realize
this will not be drag and drop.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBAhttp://gregorybeamer.spaces.live.com

********************************************
Think outside the box!





- Visa citerad text -
Click to expand...

You can repurpose the columns? I don't get that part. Does this mean
that the designer will always generate Decimal fields for Oracle
number and integer columns? I have tried with different types but they
are always Decimal in the typed DataSet.
 
Back
Top