Most of the Math.XXX methods are translated into SQL.

var q = from x in db.Transactios where Math.Abs(x.Amount) > 100 orderby x.Date descending, x.Id select x;