使用LINQ获取具有properties =另一个对象属性的对象
本文关键字:一个对象 属性 对象 properties LINQ 获取 使用 | 更新日期: 2023-09-27 18:08:51
具有以下伪代码:
class Foo
{
public int id { get; set; }
public string info { get; set; }
}
class Bar
{
public int id { get; set; }
public int FooId { get; set; }
public string moreInfo { get; set; }
}
IList<Foo> foos = new List<Foo>();
foos.Add(new Foo() { id = 1, info = "first!" });
foos.Add(new Foo() { id = 2, info = "second!" });
foos.Add(new Foo() { id = 3, info = "third!" });
IList<Bar> bars = new List<Bar>();
bars.Add(new Bar() { id = 1, FooId = 1, moreInfo = "Something" });
bars.Add(new Bar() { id = 2, FooId = 1, moreInfo = "else" });
bars.Add(new Bar() { id = 3, FooId = 2, moreInfo = "here" });
bars.Add(new Bar() { id = 4, FooId = 6, moreInfo = "and" });
bars.Add(new Bar() { id = 5, FooId = 7, moreInfo = "here as well" });
var returnValue = select bar from bars
where bar.FooId IN foos.Id
我想要实现的是一个列表(我的returnValue)包含具有id 1,2和3的栏,因为它们的FooId在foos列表中。我怎样才能得到它呢?
var returnValue = bars.Where(b => foos.Select(f => f.Id).Contains(b.FooId);
或
var returnValue = from b in bars
join f in foos on b.FooId equals f.Id
select b;
您可以使用这样的连接子句
from bar in bars
join foo in foos on bar.FoorId equals foo.id
select bar
你可以尝试这样做:
var filteredBars = bars.Join(foos, x=>x.FooId, y=>y.id, (x, y) => x);