我是菜鳥工程師

// 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();