• 当用反射获取一个model,这个model里面字段有nullable的时候,获取字段真实类型


    Using Reflection to Determine whether an Type is Nullable And Get the underlying Type

    /// <summary>
     /// Converts a Generic List into a DataTable
     /// </summary>
     /// <param name="list"></param>
     /// <param name="typ"></param>
     /// <returns></returns>
     private DataTable GetDataTable(IList list, Type typ)
     {
         DataTable dt = new DataTable();
    
         // Get a list of all the properties on the object
         PropertyInfo[] pi = typ.GetProperties();
    
         // Loop through each property, and add it as a column to the datatable
         foreach (PropertyInfo p in pi)
         {
             // The the type of the property
             Type columnType = p.PropertyType;
    
             // We need to check whether the property is NULLABLE
             if (p.PropertyType.IsGenericType && p.PropertyType.GetGenericTypeDefinition() == typeof(Nullable<>))
             {
                 // If it is NULLABLE, then get the underlying type. eg if "Nullable<int>" then this will return just "int"
                 columnType = p.PropertyType.GetGenericArguments()[0];
             }
    
             // Add the column definition to the datatable.
             dt.Columns.Add(new DataColumn(p.Name, columnType));
         }
    
         // For each object in the list, loop through and add the data to the datatable.
         foreach (object obj in list)
         {
             object[] row = new object[pi.Length];
             int i = 0;
    
             foreach (PropertyInfo p in pi)
             {
                 row[i++] = p.GetValue(obj, null);
             }
    
             dt.Rows.Add(row);
         }
    
         return dt;
     }



  • 相关阅读:
    记一次dba面试
    MySQL登陆 socket 问题
    推荐一些MySQL的博文(持续更新)
    MySQL 参数调优工具--tuning-primer
    当扫描的数据超过了全表的17%就不使用索引
    MySQL 5.7 新增参数
    MySQL 5.7 和 MySQL 5.6参数默认值比较
    MySQL创建的用户无法从本地登陆
    含有IN的子查询
    索引大小对语句执行速度的影响
  • 原文地址:https://www.cnblogs.com/tongdengquan/p/6090466.html
Copyright © 2020-2023  润新知