Enterprise Library, OracleTypes and their mapping
August 27, 2008
Things has been quite hectic since we are closing in on a sprint demo… Seems to be working now, fingers crossed.
I have done a lot of findings the last days and most of them has to do with Oracle. This has to do with me not having any experience with Oracle.
We are using Enterprise Library 4 to access the Oracle database and it’s stored procedures. It internal is using the ODP.NET client access components.
One problem we have encountered is that the data types used by Enterprise Library is generic (DBCommand, DBTypes etc) and it is mapped to the Oracle equivalents (OracleCommand, OracleTypes). So I needed a chart on my table showing me how to map between them.
But after a while I found a better way. Enterprise Library is exposing a OracleDatabase with the Oracle-flavor of the command types. By using that...