OA supports all linq syntax ?

2 posts, 0 answers
  1. BekirSami
    BekirSami avatar
    12 posts
    Member since:
    Sep 2010

    Posted 05 Jan 2011 Link to this post

    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;
  2. Thomas
    Admin
    Thomas avatar
    590 posts

    Posted 05 Jan 2011 Link to this post

    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
    Accelerate your learning with industry's first Telerik OpenAccess ORM SDK. Download today.
  3. DevCraft banner
Back to Top