OracleDbTypeNameToClientTypeResolver

This IResolver<string, Type> implementation converts an Oracle column data type name — as returned by ALL_TAB_COLUMNS.DATA_TYPE — into its equivalent .NET CLR type (e.g. VARCHAR2 → string, NUMBER → decimal, BLOB/RAW → byte[]). It also handles the TIMESTAMP(n) [WITH [LOCAL] TIME ZONE] and INTERVAL ... TO ... qualifier forms. It is the default DbTypeResolver used by OracleDbHelper.

Usability

var resolver = new OracleDbTypeNameToClientTypeResolver();
var clrType = resolver.Resolve("VARCHAR2"); // typeof(string)