T-SQL Statement with Linq2Sql
===

I try to convert the following SQL Select statement in Linq2SQL:

> SELECT        StopTimes.StopId, Trips.TripId, StopTimes.Sequence
FROM            Trips INNER JOIN
                         StopTimes ON StopTimes.TripId = Trips.TripId
WHERE        (Trips.RouteId = '3') AND (Trips.EndPlace = 'END001')
ORDER BY StopTimes.Sequence DESC

It work well but with linq2sql, I get an exception with this following statement:

    var first = (from tableTrip in db.Trips
                             join tableStopTimes in db.StopTimes on tableTrip.TripId equals tableStopTimes.TripId
                             where tableTrip.RouteId == 3 && tableTrip.EndPlace == "TAEND"
                             select new
                             {
                                 tableStopTimes.StopId,
                                 tableStopTimes.Radius,
                                 tableStopTimes.PlaceName,
                                 tableStopTimes.Place,
                                 tableStopTimes.Sequence
                             }).OrderByDescending(X => X.Sequence).First();

Thanks

 