PostgreSQL case-insensitive

LINQ StartsWith , EndsWith , and Contains are case sensitive and return false if two same string s are of different cases, e.g., ” STRING ” and ” string “.

The LIKE statement is used for searching records with partial strings in MySQL. By default the query with LIKE matches case-insensitive recores . Means query will match both records in lowercase or uppercase.

LINQ StartsWith , EndsWith , and Contains are case sensitive and return false if two same string s are of different cases, e.g., ” STRING ” and ” string “.