日期:2014-05-17 浏览次数:20430 次
var result1 = from a in t.T_BaseBookInfo
join b in t.T_BorrowInfoHsty //表
on a.GUID equals b.BookID
join c in t.T_BaseBookInfo //表
on b.BookID equals c.GUID
join d in t.T_Press
on c.PressCode equals d.PressCode
select new BorrowRankingModel //BorrowRankingModel 为自建模型
{
GUID = b.BookID,
PressName=d.PressName,
Author=c.Author,
BookTitle=c.BookTitle
};