public static void Test2()
{
using (var context = new DefectModelDataContext())
{
context.Log = Console.Out;
var query = from defect in context.Defect
join proj in context.Project
on defect.Project equals proj.ProjID
select new { defect.DefectSummary, proj.ProjName };
foreach (var item in query)
{
Console.WriteLine(string.Format("defect:{0},project:{1}", item.DefectSummary, item.ProjName));
}
}
}
public static void Test1()
{
using (var context = new DefectModelDataContext())
{
context.Log = Console.Out;
DefectUser zhangsan = context.DefectUser
.Where(user => user.UserID == "zhangsan")
.Single();
var query = from defect in context.Defect
where defect.DefectStatus != "Closed"
where defect.AssignedTo == zhangsan.UserID
select defect.DefectSummary;
foreach (var summary in query)
{
Console.WriteLine(summary);
}
}
}
