Text Querying with EF Core and SQL Server
Introduction SQL Server provides a number of functions that can be used for non-exact text queries over text columns ( CHAR , NCHAR , VARCHAR , NVARCHAR , TEXT , NTEXT ). These include searching a piece of text contained inside another, using full text search, or using patterns, and computing a code from a text. Some of them are: CONTAINS : Searches for precise or fuzzy (less precise) matches to single words and phrases, words within a certain distance of one another, or weighted matches in SQL Server DIFFERENCE : This function returns an integer value measuring the difference between the SOUNDEX values of two different character expressions FREETEXT : Is a predicate used in the Transact-SQL WHERE clause of a Transact-SQL SELECT statement to perform a SQL Server full-text search on full-text indexed columns containing character-based data types LIKE : Determines whether a specific character string matches a specified pattern PATINDEX : Returns the startin...