Sin , Cos and other trigonometric functions from the class System.Math . var emplyee = ( from emoloyee in db.Employees select new { EmployeeId = employee.EmployeeId, OrderIDs = employee.Orders.Select(o => o.OrderId) } ).ToArray(); In versions prior to 3.3.3.CR1, the processing of theTake()method contained a logical error: it did not matter where the call to this method was located — it was always processed as if the method call was located at the end. In version 3.3.3, this behavior was corrected - nowTake()processed correctly in accordance with its semantics. Thus, the following queries may produce different results.session.Query<Foo>.OrderBy(...).Take(5).Where(...);session.Query<Foo>.Where(...).OrderBy(...).Take(5);
In version 3.3.3 and above, the first query will generate a subquery that will apply the limit on the number of rows before the where condition.
Source: https://habr.com/ru/post/173137/
All Articles