public List <ConfigIndexModel> Get()
        {
            List <ConfigIndexModel> list = new List <ConfigIndexModel>();

            this.DataProvider.ExecuteCmd("dbo.Config_SelectAll"
                                         , inputParamMapper : null
                                         , singleRecordMapper : delegate(IDataReader reader, short set)
            {
                ConfigIndexModel singleItem = MapConfigIndexModel(reader);
                list.Add(singleItem);
            });

            return(list);
        }
        private ConfigIndexModel MapConfigIndexModel(IDataReader reader)
        {
            ConfigIndexModel singleItem = new ConfigIndexModel();
            int startingIndex           = 0; //startingOrdinal

            singleItem.Id           = reader.GetSafeInt32(startingIndex++);
            singleItem.ConfigName   = reader.GetSafeString(startingIndex++);
            singleItem.ConfigValue  = reader.GetSafeString(startingIndex++);
            singleItem.Description  = reader.GetSafeString(startingIndex++);
            singleItem.CategoryName = reader.GetSafeString(startingIndex++);
            singleItem.DataTypeName = reader.GetSafeString(startingIndex++);
            singleItem.CreatedDate  = reader.GetSafeDateTime(startingIndex++);
            singleItem.ModifiedDate = reader.GetSafeDateTime(startingIndex++);
            singleItem.ModifiedBy   = reader.GetSafeString(startingIndex++);
            return(singleItem);
        }