C# extension-methods entity-framework c#-4.0

为具有相同结构和不同列数的类创建扩展方法

发布于 2025-01-05 16:55:32 字数 386 浏览 1 评论 0原文

我有一个实体框架数据模式，我向其中插入一些存储过程，并为每个 SP 创建一个复杂类型。例如，我的 sp 1 具有此复杂类型：

sp1_result
{
      string c1;
      string c2;
      string c3;
      string c4;
}

例如 sp 2 具有此复杂类型：

sp2_result
{
      string c1;
      string c2;
}

等等.我想将这个复杂结果的列表转换为DataTable，但它们具有不同的列数，但它们的类型相同。我如何为此编写一个扩展方法？

谢谢

原文

I have a Entity Framework data mode that I insert to it some stored procedure and for every of those SPs I create a complex type.For example my sp 1 has this complex type:

sp1_result
{
      string c1;
      string c2;
      string c3;
      string c4;
}

and for example sp 2 has this complex type:

sp2_result
{
      string c1;
      string c2;
}

and so on.I want to convert List of this complex results to DataTable but they have different number of columns but their types are equal. How I can write an Extension Method for this?

thanks

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

遮云壑 2025-01-12 16:55:32

它利用反射并从对象的 List 集合中创建 DataTable...

        /// <summary>
        /// Converts IList object to Datatable
        /// </summary>
        /// <typeparam name="T"> name of the class - List Type</typeparam>
        /// <param name="pList"> IList object</param>
        /// <returns>Datatable</returns>
        public static DataTable ConvertTo<T>(IList<T> pList)
        {
            DataTable table = CreateTable<T>();
            Type entityType = typeof(T);
            PropertyDescriptorCollection properties = TypeDescriptor.GetProperties(entityType);

            foreach (T item in pList)
            {
                DataRow row = table.NewRow();

                foreach (PropertyDescriptor prop in properties)
                {
                    row[prop.Name] = prop.GetValue(item);
                }
                table.Rows.Add(row);
            }

            return table;
        }

which make use of reflection and create DataTable form the List collection of the object...

        /// <summary>
        /// Converts IList object to Datatable
        /// </summary>
        /// <typeparam name="T"> name of the class - List Type</typeparam>
        /// <param name="pList"> IList object</param>
        /// <returns>Datatable</returns>
        public static DataTable ConvertTo<T>(IList<T> pList)
        {
            DataTable table = CreateTable<T>();
            Type entityType = typeof(T);
            PropertyDescriptorCollection properties = TypeDescriptor.GetProperties(entityType);

            foreach (T item in pList)
            {
                DataRow row = table.NewRow();

                foreach (PropertyDescriptor prop in properties)
                {
                    row[prop.Name] = prop.GetValue(item);
                }
                table.Rows.Add(row);
            }

            return table;
        }

回复收藏 0 原文

~没有更多了~