On 01/04/2016 01:49 AM, rumbu wrote:
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
Misunderstanding. Please re-read what I wrote. -- Andrei
