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

m-m.png

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();
arrow
arrow
    全站熱搜

    give 發表在 痞客邦 留言(0) 人氣()