Return to Snippet

Revision: 2926
at May 9, 2007 20:04 by rengber


Initial Code
private void AddParameters(Database db, DbCommand comm, PropertyInfo[] properties, ListDictionary parameters, object target)
        {
            foreach (PropertyInfo pi in properties)
            {
                string paramName = pi.Name;
                if (parameters.Contains(paramName))
                {
                    System.Data.DbType paramType = (System.Data.DbType)parameters[paramName];
                    object value = pi.GetValue(target, null);
                    db.AddInParameter(comm, paramName, paramType, value);
                }
            }

        }

Initial URL


Initial Description
You could eliminate the ListDictionary if you created a simple method to map C# types to DbTypes.  Although this method also lets you skip over some object properties my using the ListDictionary to contain a subset of properties.  It could also be used to map properties to param names if they needed to differ.

Initial Title
Adding Parameters to a Command Object Using Relection Over Matching Class Properties

Initial Tags
command

Initial Language
C#