public IEnumerable<Message> GetMessages(int moduleId, Guid roomId)
{
IEnumerable<Message> t;
using (var ctx = DataContext.Instance())
{
var rep = ctx.GetRepository<Message>();
//filter by the Room id
t = (from a in rep.Get(moduleId) where a.RoomId == roomId select a).OrderByDescending(x => x.MessageDate);
//t = rep.Get(moduleId).OrderByDescending(x => x.MessageDate);
}
return t;
}