WCF返回表datatable时的解决

时间:2023-03-09 18:55:05
WCF返回表datatable时的解决

在WCF中有时返回值类型是一张表,就会遇到反序列化的问题。解决该问题我归纳了两种方法:

1、根据Model层的类,在服务器端将Table转化成List,在客户端再将List转化为table

/// 将集合类转换成DataTable
        /// </summary>
        /// <param name="list">集合</param>
        /// <returns></returns>
        public static DataTable ToDataTable(IList list)
        {
            DataTable result = new DataTable();
            if (list.Count > 0)
            {
                PropertyInfo[] propertys = list[0].GetType().GetProperties();
                foreach (PropertyInfo pi in propertys)
                {
                    result.Columns.Add(pi.Name, pi.PropertyType);
                }

for (int i = 0; i < list.Count; i++)
                {
                    ArrayList tempList = new ArrayList();
                    foreach (PropertyInfo pi in propertys)
                    {
                        object obj = pi.GetValue(list[i], null);
                        tempList.Add(obj);
                    }
                    object[] array = tempList.ToArray();
                    result.LoadDataRow(array, true);
                }
            }
            return result;
        }

2、直接在服务端为表命名,Dt.TableName="aaa";