1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
| var result = (from o in db.messages
let msgFrom = o.fromUid == uid
let msgTo = o.toUid == uid
where msgFrom || msgTo
group o by msgTo ? o.fromUid : o.toUid into grp
let lastDate = grp.Max(m => m.createDate)
from p in grp
where p.createDate == lastDate
select new viewMessage
{
uid = p.fromUid == uid ? p.toUid : p.fromUid,
name = p.fromUid == uid ? p.toemployees.name : p.fromemployees.name,
msg = p.msg,
lastdate = p.createDate,
unread = p.unread
}).AsEnumerable();
|