Using Microsoft Enterprise Library Data Access Application Block – Part II

using System;
using System.Data;
using Robin.Sample.Framework;


namespace Robin.Sample.Data
{
    public abstract class DataAccessComponent
    {
        protected string ConnectionString
        {
            get { return ConfigurationData.DBConnectionString; }
        }

        protected T GetDataValue<T>(IDataReader vobjDataReader, string vstrColumnName)
        {
            // NOTE: GetOrdinal() is used to automatically determine where the column
            //       is physically located in the database table. This allows the
            //       schema to be changed without affecting this piece of code.
            //       This of course sacrifices a little performance for maintainability.

            int intOrdinal = vobjDataReader.GetOrdinal(vstrColumnName);

            if (!vobjDataReader.IsDBNull(intOrdinal))
                return (T)vobjDataReader.GetValue(intOrdinal);
            else
                return default(T);
        }

        protected T GetDataValue<T>(IDataReader vobjDataReader, int vintColumnIndex)
        {
            if (!vobjDataReader.IsDBNull(vintColumnIndex))
                return (T)vobjDataReader.GetValue(vintColumnIndex);
            else
                return default(T);
        }
    }
}