求一linq语句,关于集合join的

[88480]

class product
{
public string name{get;set;}
public string price{get;set;}
}

List<product> p1 = new List<product>()
{
new product(){name="p1",price="100"},
new product(){name="p11",price="102"},
new product(){name="p111",price="103"}
};

List<product> p2 = new List<product>()
{
new product(){name="p1",price="200"},
new product(){name="p22",price="201"},
new product(){name="p222",price="222"}
};

想得到结果：
product:
p1,200
p1,100
====
也就是name相同的所有结果

[wuyq11]

var result = (from p in p1
join g in p2 on p.name equal g.name
select new { p1.name,p1.price })
Concat
(from p in p2
join g in p1 on p.name equal g.name
select new { p1.name,p1.price })

foreach (var p in result)
{
Console.WriteLine(p.name + "," + p.price);
}

[88480]

List<product> ps = new List<product>();
ps.AddRange(p1);
ps.AddRange(p2);
var q = from p in ps
group p by p.name into g
where g.Count() == 2
select g;
这个是我的方案

[liaoyukun111]

[Quote=引用 5 楼 ojlovecd 的回复:]
C# codevar temp= p1.Union(p2);var result=from pr1in tempfrom pr2in tempwhere pr1.name== pr2.name&& pr1!= pr2select pr1;foreach (var rin result)
Console.WriteLine(r.name+","+ r.price);
[/Quote]
这个第一句,和你的差不多

[wuyq11]

var p = from t1 in a
from t2 in b
where t1.name equal t2.name
select new
{
t2.name
}
http://topic.csdn.net/u/20091108/00/ce4dd3fe-8498-419a-87d3-f9bc80644578.html

[Error_Code]

[Quote=引用 1 楼 wuyq11 的回复:]
var p = from t1 in a
        from t2 in b
        where t1.name equal t2.name
        select new
        {
          t2.name
        }
[/Quote]
这样t1 没有select出来呢

[88480]

其实我知道怎么写，还想看看有没有更好的方法

[88480]

[Quote=引用 1 楼 wuyq11 的回复:]
var p = from t1 in a
        from t2 in b
        where t1.name equal t2.name
        select new
        {
          t2.name
        }
http://topic.csdn.net/u/20091108/00/ce4dd3fe-8498-419a-87d3-f9bc80644578.html

[/Quote]

你这个不符合要求：

想得到结果：
product:
p1,200
p1,100

[我姓区不姓区]

            var temp = p1.Union(p2);
            var result = from pr1 in temp from pr2 in temp where pr1.name == pr2.name && pr1 != pr2 select pr1;
            foreach (var r in result)
                Console.WriteLine(r.name + "," + r.price);