Convert WMI CimType to System.Type

Question

I am trying to write a generic extension to turn a ManagementObjectCollection into a DataTable. It just makes it easier to run the script / program that I am writing. I ran into a problem with CimType. I have included the code that I have written so far below.

    public static DataTable GetData(this ManagementObjectCollection objectCollection)
    {
        DataTable table = new DataTable();

        foreach (ManagementObject obj in objectCollection)
        {
            if (table.Columns.Count == 0)
            {
                foreach (PropertyData property in obj.Properties)
                {
                    table.Columns.Add(property.Name, property.Type);
                }
            }

            DataRow row = table.NewRow();

            foreach (PropertyData property in obj.Properties)
            {
                row[property.Name] = property.Value;
            }

            table.Rows.Add(row);
        }

        return table;
    }
}

I found a method that I think will work on http://www.devcow.com/blogs/adnrg/archive/2005/09/23/108.aspx . However, it seems to me that there might be a better way, or even a .net function that I am missing.

I think I did not make it clear. The problem I am facing is that I need to convert from System.Management.CimType to System.Type. I almost thought this would be a common problem, but I suppose I'm trying to solve it in a general way.

Answer 1

:

public static class CimConvert
{

private readonly static IDictionary<CimType, Type> Cim2TypeTable =
    new Dictionary<CimType, Type>
        {
            {CimType.Boolean, typeof (bool)},
            {CimType.Char16, typeof (string)},
            {CimType.DateTime, typeof (DateTime)},
            {CimType.Object, typeof (object)},
            {CimType.Real32, typeof (decimal)},
            {CimType.Real64, typeof (decimal)},
            {CimType.Reference, typeof (object)},
            {CimType.SInt16, typeof (short)},
            {CimType.SInt32, typeof (int)},
            {CimType.SInt8, typeof (sbyte)},
            {CimType.String, typeof (string)},
            {CimType.UInt8, typeof (byte)},
            {CimType.UInt16, typeof (ushort)},
            {CimType.UInt32, typeof (uint)},
            {CimType.UInt64, typeof (ulong)}
        };

public static Type Cim2SystemType(this PropertyData data)
{
    Type type = Cim2TypeTable[data.Type];
    if (data.IsArray)
        type = type.MakeArrayType();
    return type;
}

public static object Cim2SystemValue(this PropertyData data)
{
    Type type = Cim2SystemType(data);
    if (data.Type == CimType.DateTime)
        return DateTime.ParseExact(data.Value.ToString(), "yyyyMMddHHmmss.ffffff-000", CultureInfo.InvariantCulture);
    return Convert.ChangeType(data.Value, type);
}
}

Answer 2

ParseExtract , "-000" :

public static DateTime GetDateTimeValue(this PropertyData pd)
{
    if (pd.Type == CimType.DateTime)
    {
        string format = "yyyyMMddHHmmss.ffffff";
        string val = pd.Value.ToString().Substring(0,format.Length);
        DateTime ret = DateTime.ParseExact(val, format, System.Globalization.CultureInfo.InvariantCulture);
        return ret;
    }
    throw new ArgumentException();
}

Answer 3

Here is the function that I ended up using, this is a modified form of the one I posted in the link. It is strange that there is no system function for this.

    /**
    * <summary>
    *   This function converts a WMI CimType to a System.Type
    *   It was copied from: http://www.devcow.com/blogs/adnrg/archive/2005/09/23/108.aspx
    * </summary>
    */
    private static System.Type ConvertCimType(PropertyData property)
    {
        System.Type tReturnVal = null;

        switch (property.Type )
        {
            case CimType.Boolean:
                tReturnVal = typeof(System.Boolean);
                break;

            case CimType.Char16:
                tReturnVal = typeof(System.String);
                break;

            case CimType.DateTime:
                tReturnVal = typeof(System.DateTime);
                break;

            case CimType.Object:
                tReturnVal = typeof(System.Object);
                break;

            case CimType.Real32:
                tReturnVal = typeof(System.Decimal);
                break;

            case CimType.Real64:
                tReturnVal = typeof(System.Decimal);
                break;

            case CimType.Reference:
                tReturnVal = typeof(System.Object);
                break;

            case CimType.SInt16:
                tReturnVal = typeof(System.Int16);
                break;

            case CimType.SInt32:
                tReturnVal = typeof(System.Int32);
                break;

            case CimType.SInt8:
                tReturnVal = typeof(System.SByte);
                break;

            case CimType.String:
                tReturnVal = typeof(System.String);
                break;

            case CimType.UInt16:
                tReturnVal = typeof(System.UInt16);
                break;

            case CimType.UInt32:
                tReturnVal = typeof(System.UInt32);
                break;

            case CimType.UInt64:
                tReturnVal = typeof(System.UInt64);
                break;

            case CimType.UInt8:
                tReturnVal = typeof(System.Byte);
                break;
        }

        // do a final check
        tReturnVal = CheckType(property, tReturnVal);

        return tReturnVal;
    }


    private static System.Type CheckType(PropertyData property, System.Type itemType)
    {
        if (property.IsArray)
        {
            return System.Type.GetType( itemType.ToString() + "[]" );

        }
        else
        {
            return itemType;
        }
    }