如何在LINQ中向其他输入查询? [英] How to Input a query to other In LINQ?

问题描述

我正在用linq从C#中的数据表中获取数据

I am getting data from datatable in c# by linq

List<class> O=new List<class>();

var query=from p in dt.AsEnumerable()
          let val= p.Field<string>("Column")

          select new
          {
           _value=val
          };
   
O.AddRange(query.toList());

在查询中有时会是1，有时会是多个值

前任. query =这就是它"
或query ="This is it"，"This Is That"，它有两个_value

现在我想提供_query作为输入以从其他数据表中搜索它

e.x.

in query some time its 1 and sometime its multiple values

e.x. query="this is it"
or query="This is it", "This is That" it has two _value

now i want to give _query as input to search it from some other datatable

e.x.

var query2=from v in dt2.AsEnumerable()
           where (val==query.tolist())
           select Column;

我如何传递查询，并且在查询中有多个值(例如10个值)时也应该进行迭代

how can i pass the query and also it should be iterate when multiple values are in query like 10 values

推荐答案

var query2=from v in dt2.AsEnumerable()
           where (query.Any(x=>x==v.Field<string>("ColName")))
           select Column;

这篇关于如何在LINQ中向其他输入查询?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！