Solutions that ELINQ offers to some unresolved or "under investigation" issues.
| EF Core | ELINQ |
|---|---|
| Allow DbFunction to return scalar value from aggregates | fully supported |
| Invalid SQL generated with 3.1 (bug in EF) | see it working |
| Support database window functions | fully supported |
| Ability to map a CLR method returning queryable to TVF | Table UDF |
| Translate component of datetime/timespan after arithmetic operations | Passed ON to the database |
| Query: optimize arithmetic operation on constants | Thanks to the C# compiler |
| Add LINQ methods for INTERSECT ALL and EXCEPT ALL | Builtin operators |