如何将DataTable转换为类Object? [英] How to convert DataTable to class Object?

问题描述

我已经开发了一个可以在任何地方返回DataTable的应用程序.

I have already developed an application which returns DataTable everywhere.

现在我的客户想要转换(使用服务堆栈中的一部分)，所以我需要在应用程序中返回DTO (objects).

Now my client wants to convert (use some part using service stack), so I need to return DTO (objects) in my application.

我不想更改现有的存储过程，甚至不想尽可能多地使用LINQ(我对LINQ不太了解).

I don't want to change my existing stored procedures or even not want to use LINQ as much as possible (I am not too much aware with LINQ).

对于小功能，我可以使用Linq没问题.

For small functionality, I can use Linq no issue.

我的问题是:如何将DataTable更改为该类的对象?

My question is: how can I change my DataTable to objects of that class?

示例代码如下:

string s = DateTime.Now.ToString();
DataTable dt = new DataTable();

dt.Columns.Add("id");
dt.Columns.Add("name");

for (int i = 0; i < 5000000; i++)
{
    DataRow dr = dt.NewRow();
    dr["id"] = i.ToString();
    dr["name"] = "name" + i.ToString();
    dt.Rows.Add(dr);

    dt.AcceptChanges();
}

List<Class1> clslist = new List<Class1>();

for (int i = 0; i < dt.Rows.Count; i++)
{
    Class1 cls = new Class1();
    cls.id = dt.Rows[i]["id"].ToString();
    cls.name = dt.Rows[i]["name"].ToString();
    clslist.Add(cls);
}

Response.Write(s);
Response.Write("<br>");
Response.Write(DateTime.Now.ToString());

我知道，上述方法很耗时，我正在尝试寻找替代解决方案.

I know, the above method is time-consuming, and I am trying to find an alternate solution.

是否有其他方法(我想是LINQ to DataTable)可以直接将表的行转换为List<Class1>?

Is there any alternative way (I guess, LINQ to DataTable) by which it directly converts the rows of tables to List<Class1>?

这样我就可以返回服务堆栈中的对象并继续操作.

So that I can return objects in my service stack and go ahead.

推荐答案

初始化数据表:

DataTable dt = new DataTable(); 
dt.Columns.Add("id", typeof(String)); 
dt.Columns.Add("name", typeof(String)); 
for (int i = 0; i < 5; i++)
{
    string index = i.ToString();
    dt.Rows.Add(new object[] { index, "name" + index });
}

查询本身:

IList<Class1> items = dt.AsEnumerable().Select(row => 
    new Class1
        {
            id = row.Field<string>("id"),
            name = row.Field<string>("name")
        }).ToList();

这篇关于如何将DataTable转换为类Object?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！