Supported MSSQL functions
List of MSSQL functions supported by Linqer.
LINQ to SQL model.
String functions:
| CHAR | CHARINDEX | LEN |
| LEFT | LOWER | LTRIM |
| RIGHT | REPLACE | RTRIM |
| STR | STUFF | SUBSTRING |
| UPPER |
Date Functions:
| DATEADD | DATEPART | DAY |
| MONTH | YEAR | GETDATE |
Math Functions:
| ABS | ACOS | ASIN |
| ATAN | ATN2 | CEILING |
| COS | COT | DEGREES |
| EXP | LOG | LOG10 |
| PI | POWER | RADIANS |
| RAND | ROUND | SIGN |
| SQRT | SQUARE | TAN |
Other functions:
| CAST | COALESCE | CONVERT |
| ISNULL | NULLIF |
LINQ to Entities model.
String functions:
| CHARINDEX | LEN | LEFT |
| LOWER | LTRIM (C# only) | RIGHT |
| REPLACE | RTRIM (C# only) | STUFF |
| SUBSTRING | UPPER |
Date Functions:
| DATEADD | DATEPART | DAY |
| MONTH | YEAR | GETDATE |
Math Functions:
| CEILING | DEGREES | PI |
| RADIANS | SQUARE |
Other functions:
| COALESCE | ISNULL | NULLIF |