Unsupported expressions
This topic describes Transact-SQL expressions that are not supported in Entity SQL. For more information, see How Entity SQL Differs from Transact-SQL.
Quantified predicates
Transact-SQL allows constructs of the following form:
sal > all (select salary from employees)
sal > any (select salary from employees)
Entity SQL, however, does not support such constructs. Equivalent expressions can be written in Entity SQL as follows:
not exists(select 0 from employees as e where sal <= e.salary)
exists(select 0 from employees as e where sal > e.salary)
* operator
Transact-SQL supports the use of the * operator in the SELECT clause to indicate that all columns should be projected out. This is not supported in Entity SQL.