[Solved] OA supports all linq syntax ?

[BekirSami]

Following linq works with LinqPad but with Open Access gives error.

var rows = from vp1 in Context.VehiclePositionHistories
          from v in Context.Vehicles
          where vp1.VehicleId == v.Id
          && vp1.Id ==
            (
                from vp2 in Context.VehiclePositionHistories
                where vp2.VehicleId == v.Id
                select vp2.Id
             ).Max()
          select vp1;

[Thomas]

Hi Hasan,

looks like an issue with this query. However, I was thinking if grouping wouldn't be more appropriate for your specific case as you wish to obtain the max() per vehicle.

I will have a look into that.

Best wishes,
Thomas
the Telerik team