Continuing with the LINQ tips, today we provide a list of System.Math methods that we are going to support with the upcoming Q3 release. The following table shows the supported methods; when no indication is given, all the overloaded (double,decimal,...) versions will work.
(*) Only the Round(double) and Round(x,y) methods where y!=MidpointRounding are supported.
That means, you can push now many more calculations to the database server. Be aware however, that using the database server engine might produce different results than would be calculated when the CLR is used; e.g. when an Oracle NUMBER column is used as the storage for a field, the precision used in a calculation involving that column can be different from the CLR precision for the float/double/decimal field.
Copyright © 2017, Progress Software Corporation and/or its subsidiaries or affiliates. All Rights Reserved.
Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks or appropriate markings.