摘要:LinQ的Join搭配LET的用法
記錄一下 ^_^
public partial class Default2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
List<MyClass1> l = new List<MyClass1>(){
new MyClass1{Name="dyco",Description="It's Boy"},
new MyClass1{Name="Chen",Description="It's Girl"}
};
List<MyClass2> l1 = new List<MyClass2>(){
new MyClass2{Name="dyco",Info="備註一"},
new MyClass2{Name="dyco",Info="備註二"}
};
var r = from i in l
where i.Name == "dyco"
join i1 in l1 on i.Name equals i1.Name into g
let iii=from g1 in g select new {info1=g1.Info}
select new { name = i.Name, infoColl = iii } ;
foreach(var item in r){
Response.Write(item.name + "備註有:");
foreach (var item1 in item.infoColl)
{
Response.Write(item1.info1);
}
}
}
}
class MyClass1
{
public string Name { get; set; }
public string Description { get; set; }
}
class MyClass2
{
public string Name { get; set; }
public string Info { get; set; }
}