上一扁使用動態lambda表達式來將DataTable轉換成實體，比直接用反射快了不少。主要是首行轉換的時候動態生成了委托。

后面的轉換都是直接調用委托，省去了多次用反射帶來的性能損失。

今天在對SqlServer返回的流對象 SqlDataReader 進行處理，也采用動態生成Lambda表達式的方式轉換實體。

先上一版代碼

using System;using System.Collections.Generic;using System.Data;using System.Data.Common;using System.Data.SqlClient;using System.Linq;using System.Linq.Expressions;using System.Reflection;using System.Text;using System.Threading.Tasks;namespace Demo1{ public static class EntityConverter {  #region  /// <summary>  /// DataTable生成實體  /// </summary>  /// <typeparam name="T"></typeparam>  /// <param name="dataTable"></param>  /// <returns></returns>  public static List<T> ToList<T>(this DataTable dataTable) where T : class, new()  {   if (dataTable == null || dataTable.Rows.Count <= 0) throw new ArgumentNullException("dataTable", "當前對象為null無法生成表達式樹");   Func<DataRow, T> func = dataTable.Rows[0].ToExpression<T>();   List<T> collection = new List<T>(dataTable.Rows.Count);   foreach (DataRow dr in dataTable.Rows)   {    collection.Add(func(dr));   }   return collection;  }  /// <summary>  /// 生成表達式  /// </summary>  /// <typeparam name="T"></typeparam>  /// <param name="dataRow"></param>  /// <returns></returns>  public static Func<DataRow, T> ToExpression<T>(this DataRow dataRow) where T : class, new()  {   if (dataRow == null) throw new ArgumentNullException("dataRow", "當前對象為null 無法轉換成實體");   ParameterExpression parameter = Expression.Parameter(typeof(DataRow), "dr");   List<MemberBinding> binds = new List<MemberBinding>();   for (int i = 0; i < dataRow.ItemArray.Length; i++)   {    String colName = dataRow.Table.Columns[i].ColumnName;    PropertyInfo pInfo = typeof(T).GetProperty(colName);    if (pInfo == null || !pInfo.CanWrite) continue;    MethodInfo mInfo = typeof(DataRowExtensions).GetMethod("Field", new Type[] { typeof(DataRow), typeof(String) }).MakeGenericMethod(pInfo.PropertyType);    MethodCallExpression call = Expression.Call(mInfo, parameter, Expression.Constant(colName, typeof(String)));    MemberAssignment bind = Expression.Bind(pInfo, call);    binds.Add(bind);   }   MemberInitExpression init = Expression.MemberInit(Expression.New(typeof(T)), binds.ToArray());   return Expression.Lambda<Func<DataRow, T>>(init, parameter).Compile();  }  #endregion  /// <summary>  /// 生成lambda表達式  /// </summary>  /// <typeparam name="T"></typeparam>  /// <param name="reader"></param>  /// <returns></returns>  public static Func<SqlDataReader, T> ToExpression<T>(this SqlDataReader reader) where T : class, new()  {   if (reader == null || reader.IsClosed || !reader.HasRows) throw new ArgumentException("reader", "當前對象無效");   ParameterExpression parameter = Expression.Parameter(typeof(SqlDataReader), "reader");   List<MemberBinding> binds = new List<MemberBinding>();   for (int i = 0; i < reader.FieldCount; i++)   {    String colName = reader.GetName(i);    PropertyInfo pInfo = typeof(T).GetProperty(colName);    if (pInfo == null || !pInfo.CanWrite) continue;    MethodInfo mInfo = reader.GetType().GetMethod("GetFieldValue").MakeGenericMethod(pInfo.PropertyType);    MethodCallExpression call = Expression.Call(parameter, mInfo, Expression.Constant(i));    MemberAssignment bind = Expression.Bind(pInfo, call);    binds.Add(bind);   }   MemberInitExpression init = Expression.MemberInit(Expression.New(typeof(T)), binds.ToArray());   return Expression.Lambda<Func<SqlDataReader, T>>(init, parameter).Compile();  } }}