Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OracleDataAdapter.FillSchema - mapping types in db to DataTable types

Daniel LipkieFeb 20 2013 — edited Feb 20 2013
OracleDataAdapter.FillSchema(table, Source) will configure a DataTable to match a table in database schema.

How does FillSchema map types in the db schema to types associated with the DataTable columns?

E.g. if the db column is NUMBER(2,0) the DataTable column appears to be System.Int16.

How is this mapping done? Can it be configured?

Basically I'm looking for documentation on the mapping from DB definitions, to
Oracle.DataAccess.Client.OracleDbType
and
System.Data.DbType
since the Output type of OracleParameter can have its DbType to insure that the values returned are .NET types.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 20 2013
Added on Feb 20 2013
1 comment
389 views