DataExtentions

using System;
using System.Collections.Generic;
using System.Data;
using System.Diagnostics;
using System.Linq;
using System.Text;
using Oracle.DataAccess.Client;

namespace Core {

    /// <summary>
    /// System.Data Extention methods
    /// </summary>
    [DebuggerStepThrough()]
    public static class DataExtentions {

        /// <summary>
        /// Gets the data value located at the specified index.
        /// </summary>
        /// <param name="ordinal">The index of the field to find.</param>
        /// <param name="defaultValue">The value to return if reader's value is <see cref="System.DBNull"/></param>
        public static T GetReaderValue<T>(this IDataReader reader,int ordinal,T defaultValue = default(T)) {

            if(reader.IsDBNull(ordinal))
                return defaultValue;

            return (T)Convert.ChangeType(reader[ordinal],typeof(T));
        }

        /// <summary>
        /// Gets the data value located at the name of the field
        /// </summary>
        /// <param name="name">The name of the field to find.</param>
        /// <param name="defaultValue">The value to return if reader's value is <see cref="System.DBNull"/></param>
        /// <returns></returns>
        public static T GetReaderValue<T>(this IDataReader reader,string name,T defaultValue = default(T)) {
            int ordinal = reader.GetOrdinal(name);

            if(reader.IsDBNull(ordinal))
                return defaultValue;
            return (T)Convert.ChangeType(reader[ordinal],typeof(T));
        }

        /// <summary>
        /// Gets the data value located at the specified index.
        /// </summary>
        /// <param name="ordinal">The index of the field to find.</param>
        /// <param name="defaultValue">The value to return if reader's value is <see cref="System.DBNull"/></param>
        public static T GetReaderValue<T>(this OracleDataReader reader,int ordinal,T defaultValue = default(T)) {
            return ((IDataReader)reader).GetReaderValue<T>(ordinal,defaultValue);
        }

        /// <summary>
        /// Gets the data value located at the name of the field
        /// </summary>
        /// <param name="name">The name of the field to find.</param>
        /// <param name="defaultValue">The value to return if reader's value is <see cref="System.DBNull"/></param>
        /// <returns></returns>
        public static T GetReaderValue<T>(this OracleDataReader reader,string name,T defaultValue = default(T)) {
            return ((IDataReader)reader).GetReaderValue<T>(name,defaultValue);
        }
    }
}