Entity Framework內多對多表格的選取－Give

Oct 14 Wed 2009 08:48
Entity Framework內多對多表格的選取

// TblApplyTicket 和 TblMapMetadata 是多對多的關係

var result = (
from m in db.TblApplyTicket
from t in m.TblMapMetadata
where m.TblUser.UId == "N125134438"
select new
{
UseRestrict = m.ApplyId.Substring(0, 1),
ApplyId = m.ApplyId,
Status = m.Status,
ApplyDate = m.ApplyDate,
MapId = t.MapId
})
.OrderByDescending(m => m.ApplyDate)
.Take(10)
.ToArray();