将IEnumerable<DataRow>转换为EnumerableRowCollection<DataRow>或DataView

Question

我怎样才能result到EnumerableRowCollection<DataRow>或DataView

DataTable table1 = /*something*/ ;
DataTable table2 = /*something*/ ;
DataTable table3 = /*something*/ ;

IEnumerable<DataRow> result = (from t1 in table1.AsEnumerable() join 
                                    t2 in table2.AsEnumerable() on t1.Field<int>("id") equals t2.Field<int>("t1id") join
                                    t3 in table3.AsEnumerable() on t2.Field<int>("t3id") equals t3.Field<int>("id")
                               where 666.Equals(t3.Field<int>("id"))
                              select t1);

谢谢

Answer 1

正如乔恩·斯基特所说：

DataTable table1 = /*something*/ ;
DataTable table2 = /*something*/ ;
DataTable table3 = /*something*/ ;

DataTable result = (from t1 in table1.AsEnumerable() join 
                                    t2 in table2.AsEnumerable() on t1.Field<int>("id") equals t2.Field<int>("t1id") join
                                    t3 in table3.AsEnumerable() on t2.Field<int>("t3id") equals t3.Field<int>("id")
                               where 666.Equals(t3.Field<int>("id"))
                              select t1).CopyToDataTable<DataRow>();

如果您想要一个DataView：

DataTable table1 = /*something*/ ;
DataTable table2 = /*something*/ ;
DataTable table3 = /*something*/ ;

DataView result = (from t1 in table1.AsEnumerable() join 
                                    t2 in table2.AsEnumerable() on t1.Field<int>("id") equals t2.Field<int>("t1id") join
                                    t3 in table3.AsEnumerable() on t2.Field<int>("t3id") equals t3.Field<int>("id")
                               where 666.Equals(t3.Field<int>("id"))
                              select t1).CopyToDataTable<DataRow>().AsDataView();

Answer 2

来自.NET文档这里

DataTable orders = dataSet.Tables["SalesOrderHeader"];

EnumerableRowCollection<DataRow> query =
    from order in orders.AsEnumerable()
    where order.Field<bool>("OnlineOrderFlag") == true
    orderby order.Field<decimal>("TotalDue")
    select order;

DataView view = query.AsDataView();

bindingSource1.DataSource = view;