public static T ExpandObject <T>(object o, Func <FieldInfo, IDataRecord, object> customApply) where T : class, new()
        {
            Type       t             = typeof(T);
            T          returnObject  = (T)o;
            string     dictionaryKey = string.Empty;
            SqlCommand sqlCommand;

            foreach (FieldInfo fieldInfo in returnObject.GetType().GetFields())
            {
                if (Attribute.IsDefined(fieldInfo, typeof(DictionaryMapAttribute)))
                {
                    DictionaryMapAttribute dictionaryMapAttribute = (DictionaryMapAttribute)Attribute.GetCustomAttribute(fieldInfo, typeof(DictionaryMapAttribute));
                    using (DataManager.Current.OpenConnection())
                    {
                        if (!dictionaryMapAttribute.IsStoredProcedure)
                        {
                            sqlCommand = DataManager.CreateCommand(dictionaryMapAttribute.Command);
                        }
                        else
                        {
                            sqlCommand = DataManager.CreateCommand(dictionaryMapAttribute.Command, CommandType.StoredProcedure);
                        }
                        foreach (SqlParameter param in sqlCommand.Parameters)
                        {
                            string fieldName = param.ParameterName.Substring(1);                             //without the "@"
                            param.Value = returnObject.GetType().GetField(fieldName).GetValue(returnObject);
                        }

                        fieldInfo.SetValue(returnObject, GetDictionryObject(fieldInfo, sqlCommand.ExecuteReader()));
                    }
                }
            }

            return((T)returnObject);
        }
        public static IDictionary GetDictionryObject(FieldInfo fieldInfo, IDataReader sqlDataReader)
        {
            Type keyElement  = null;
            Type typeElement = null;

            //Check that it is realy dictionary
            string dictionaryKey = string.Empty;

            if (!fieldInfo.FieldType.IsGenericType || fieldInfo.FieldType.GetGenericTypeDefinition() == typeof(IDictionary))
            {
                throw new Exception("This is not generic Dictionary");
            }

            if (!Attribute.IsDefined(fieldInfo, typeof(DictionaryMapAttribute)))
            {
                throw new Exception("DictionaryMapatrribute not defined");
            }


            //build the dictionary object
            DictionaryMapAttribute dictionaryMapAttribute = (DictionaryMapAttribute)Attribute.GetCustomAttribute(fieldInfo, typeof(DictionaryMapAttribute));

            keyElement  = fieldInfo.FieldType.GetGenericArguments()[0];
            typeElement = fieldInfo.FieldType.GetGenericArguments()[1];
            IDictionary returnObject = (IDictionary)Activator.CreateInstance(fieldInfo.FieldType);

            if (typeElement.IsGenericType)
            {
                Type listArgType = typeElement.GetGenericArguments()[0];

                string[] listArgFieldsName = dictionaryMapAttribute.ValueFieldsName.Split(',');
                IList    list;

                while (sqlDataReader.Read())
                {
                    object listArg = Activator.CreateInstance(listArgType);
                    if (!returnObject.Contains(sqlDataReader[dictionaryMapAttribute.KeyName]))
                    {
                        returnObject.Add(sqlDataReader[dictionaryMapAttribute.KeyName], (IList)Activator.CreateInstance(typeElement));
                    }
                    list = (IList)returnObject[sqlDataReader[dictionaryMapAttribute.KeyName]];
                    foreach (string fieldName in listArgFieldsName)
                    {
                        listArgType.GetField(fieldName).SetValue(listArg, sqlDataReader[fieldName]);
                    }
                    list.Add(listArg);
                }
            }
            else
            {
                while (sqlDataReader.Read())
                {
                    object val;
                    if (typeElement != typeof(string))
                    {
                        val = Activator.CreateInstance(typeElement);
                    }
                    else
                    {
                        val = sqlDataReader[dictionaryMapAttribute.ValueFieldsName].ToString();
                    }
                    if (!returnObject.Contains(sqlDataReader[dictionaryMapAttribute.KeyName]))
                    {
                        returnObject.Add(sqlDataReader[dictionaryMapAttribute.KeyName], val);
                    }
                }
            }
            return(returnObject);
        }