Productivity
Welcome back for some more information about the Telerik OpenAccess ORM support for LINQ. Today we provide a brief list of the System.String properties and methods that are supported by our LINQ implementation. When any of the below listed methods are used in a LINQ query, Telerik OpenAccess ORM translates the method call to equivalent SQL which is then executed on the server. Please note that the table lists the MS SqlServer specific SQL translation. Properties String.Length len (string_expression) Methods String.CompareTo expression = expression String.Contains match_expression LIKE pattern String.EndsWith match_expression LIKE pattern String.Equals expression = expression String.IndexOf(String) CHARINDEX (expression1,expression2, –1) String.IndexOf(String,Int32) CHARINDEX (expression1,expression2, start_location) String.Insert CASE WHEN( LEN(ISNULL(column_name,'')) = start_index) THEN ISNULL(column_name,'') + value ...