LinqToOpf3 shortcommings

Developer
Aug 14, 2009 at 10:22 PM

I might be mistaking, but Cristian can correct me :)

LinqToOpf3 lacks some functionality:

- outer join support which isn't working correct;
- distinct;
- group by;
- not exists in (select .. from .. where ..)
- union;
- intersect;
- some other things?


There are also differences compared to LinqToSql

- min, max, etc using the QueryUtils class.


And i'm sure im missing more.
At my company we are very close to just using the SqlQuery class and dropping LinqToOpf3 for most of the querys.