using Oracle.ManagedDataAccess.Client; using System; using System.Data.Common; namespace Common { public class OracleReaderWrapper { private OracleDataReader _Reader; public OracleReaderWrapper(OracleDataReader reader) { this._Reader = reader; } public string GetString(string name, string defaultValue) { defaultValue = ""; try { return Convert.ToString(((DbDataReader) this._Reader)[name]); } catch { return defaultValue; } } public int GetInt(string name, int defaultValue) { defaultValue = 0; try { return Convert.ToInt32(((DbDataReader) this._Reader)[name]); } catch { return defaultValue; } } public uint GetUInt(string name, uint defaultValue) { defaultValue = 0U; try { return Convert.ToUInt32(((DbDataReader) this._Reader)[name]); } catch { return defaultValue; } } public long GetInt64(string name, long defaultValue) { defaultValue = 0L; try { return Convert.ToInt64(((DbDataReader) this._Reader)[name]); } catch { return defaultValue; } } public ulong GetUInt64(string name, ulong defaultValue) { defaultValue = 0UL; try { return Convert.ToUInt64(((DbDataReader) this._Reader)[name]); } catch { return defaultValue; } } public DateTime GetDateTime(string name) { try { return Convert.ToDateTime(((DbDataReader) this._Reader)[name]); } catch { return DateTime.MinValue; } } } }