On Monday, 4 January 2016 at 00:49:29 UTC, Andrei Alexandrescu
wrote:
Second, ET as a mechanism for SQL interface has other inherent
limitations. Consider the "LIKE" operator in SQL, which has no
ET equivalent in C++ with similar syntax, and no direct
equivalent in LINQ. That doesn't mean the respective languages
are broken.
LINQ transforms StartsWith, EndsWith and Contains methods in LIKE
queries under the hood since Entity Framework 4.0 (8 years ago).
Also, when in doubt, there is an entire namespace dedicated to
LINQ queries with direct SQL equivalents (including LIKE) -
https://msdn.microsoft.com/en-us/library/system.data.linq.sqlclient.sqlmethods(v=vs.110).aspx
