SqlLike
Ecng.Data.Sql
Builds LIKE patterns from caller-supplied text. A pattern produced here matches its input literally, provided the predicate declares EscapeChar in an ESCAPE clause — the SQL-standard clause understood alike by SQL Server, PostgreSQL, SQLite and MySQL, which is what keeps the escaping free of dialect knowledge.
Properties
Metacharacters
public static ReadOnlySpan<char> Metacharacters { get; }value = SqlLike.MetacharactersThe characters a LIKE pattern reads as instructions rather than as text, in the order they must be escaped.
Methods
EscapeLike
public static string EscapeLike(string value)result = SqlLike.EscapeLike(value)Escapes the pattern metacharacters in so that LIKE matches it as plain text.
- value
- Text to be matched literally.
Returns: The escaped text.
ToLikeContains
public static string ToLikeContains(string value)result = SqlLike.ToLikeContains(value)Builds a "contains" pattern matching literally anywhere in the compared column.
- value
- Text to be matched literally.
Returns: The pattern.
Fields
EscapeChar
public const char EscapeCharvalue = SqlLike.EscapeCharCharacter declared by the ESCAPE clause of a LIKE predicate.