View Source
Class SqlExpressionExtensions
String extension methods used specifically to translate into SQL
Assembly: Umbraco.Core.dll
Syntax
public static class SqlExpressionExtensions
Methods
View Source
SqlContains(string, string, TextColumnType)
Declaration
public static bool SqlContains(this string str, string txt, TextColumnType columnType)
Parameters
Returns
View Source
SqlEndsWith(string, string, TextColumnType)
Declaration
public static bool SqlEndsWith(this string str, string txt, TextColumnType columnType)
Parameters
Returns
View Source
SqlEquals(string, string, TextColumnType)
Declaration
public static bool SqlEquals(this string str, string txt, TextColumnType columnType)
Parameters
Returns
View Source
SqlIn<T>(IEnumerable<T>, T)
Declaration
public static bool SqlIn<T>(this IEnumerable<T> collection, T item)
Parameters
| Type |
Name |
Description |
| IEnumerable<T> |
collection |
|
| T |
item |
|
Returns
Type Parameters
View Source
SqlNullableEquals<T>(T?, T?, T)
Indicates whether two nullable values are equal, substituting a fallback value for nulls.
Declaration
public static bool SqlNullableEquals<T>(this T? value, T? other, T fallbackValue) where T : struct
Parameters
| Type |
Name |
Description |
| T? |
value |
The value to compare.
|
| T? |
other |
The value to compare to.
|
| T |
fallbackValue |
The value to use when any value is null.
|
Returns
Type Parameters
| Name |
Description |
| T |
The nullable type.
|
View Source
SqlStartsWith(string?, string, TextColumnType)
Declaration
public static bool SqlStartsWith(this string? str, string txt, TextColumnType columnType)
Parameters
Returns
View Source
SqlWildcard(string, string, TextColumnType)
Declaration
public static bool SqlWildcard(this string str, string txt, TextColumnType columnType)
Parameters
Returns