static void Main(string[] args)
{
using (var writer = new StreamWriter(WatchSqlPath, false, Encoding.UTF8))
{
using (DbAppDataContext db = new DbAppDataContext())
{
db.Log = writer;
//inner join
var query = from s in db.Students
join c in db.Classes on s.ClassID equals c.ClassID
where c.ClassID == 1
select new
{
ClassID = s.ClassID,
ClassName = c.ClassName,
Student = new
{
Name = s.Name,
ID = s.StudentID
}
};
foreach (var item in query)
{
Console.WriteLine("{0} {1} {2}", item.ClassID, item.ClassName, item.Student.Name);
}
}
}
Console.ReadLine();
}
static void Main(string[] args)
{
using (var writer = new StreamWriter(WatchSqlPath, false, Encoding.UTF8))
{
using (DbAppDataContext db = new DbAppDataContext())
{
db.Log = writer;
//left outer join
var query = from s in db.Students
join c in db.Classes on s.ClassID equals c.ClassID into gc
from gci in gc.DefaultIfEmpty()
select new
{
ClassID = s.ClassID,
ClassName = gci.ClassName,
Student = new
{
Name = s.Name,
ID = s.StudentID
}
};
foreach (var item in query)
{
Console.WriteLine("{0} {1} {2}", item.ClassID, item.ClassName, item.Student.Name);
}
}
}
Console.ReadLine();
}
<span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 19.5px; background-color: rgb(254, 254, 242);">Outer join时必须将join后的表into到一个新的变量gc中,然后要用gc.DefaultIfEmpty()表示外连接。</span>