C# Datatable换为模型

/// <summary>
/// Datatable转为模型
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="dt"></param>
/// <returns></returns>
public static IEnumerable<T> DataTableToModel<T>(DataTable dt)
    where T : new()
{
    Type type = typeof(T);
    List<T> list = new List<T>();
    List<PropertyInfo> properties = new List<PropertyInfo>();
    foreach (PropertyInfo info in type.GetProperties())
    {
        if (info.PropertyType.IsValueType || info.PropertyType == typeof(string))
        {
            properties.Add(info);
        }
    }
    foreach (DataRow dr in dt.Rows)
    {
        T t = new T();
        for (int i = 0; i < properties.Count; i++)
        {
            if (dt.Columns.Contains(properties[i].Name))
            {
                properties[i].SetValue(t, dr[properties[i].Name] != DBNull.Value ? dr[properties[i].Name] : "");
            }
        }
        list.Add(t);
    }
    return list;
}