linq 查不出数据

C# code

public IEnumerable Necro_overdueQuery(){ TombDataContext db = new TombDataContext();            var query = from d in db.d_necro                            join re in db.ReBook                             on d.ano equals re.Fano into temp                             from temp1 in temp.DefaultIfEmpty()                             //where DateTime.Now.AddYears(-20) > d.buryday &&                             //DateTime.Now.AddYears(-20) > re.bookDate                             select new                             {                                 d.ano,d.fno,d.goname,d.goaddr,                                                temp1.bookId,                                 temp1.bookDate,                                 reremark = temp1.remark                             };                return query;}

为什么查不出数据 哪里有问题 还有左连接是不是该这么写。加菲猫 快出来。

[解决办法]
不用into temp。
from d in db.d_necro join re in db.ReBook on d.ano equals re.Fano
select new {
d.ano,d.fno,d.goname,d.goaddr,
re.bookId,re.bookDate,re.remark
};