LINQ Join does not work

[lnetrebskii]

Join operation does not work. The next query returns an empty object for BookingStatus.

_context.CreateQuery<BookableResourceBooking>()
                .Join(_context.CreateQuery<BookingStatus>(),
                    brb => brb.BookingStatus.Id,
                    st => st.Id,
                    (brb, st) => new { Brb = brb, Status = st }
                    )
                .Where(x => x.Status.Status != BookingStatus_Status.Canceled &&
                            x.Brb.msdyn_WorkOrder.Id == workOrderId)
                .Select(x =>
                    new Tuple<BookableResourceBooking, BookingStatus>(
                        new BookableResourceBooking
                        {
                            Id = x.Brb.Id,
                            BookingStatus = x.Brb.BookingStatus,
                            StartTime = x.Brb.StartTime,
                            Resource = x.Brb.Resource,
                            msdyn_WorkOrder = x.Brb.msdyn_WorkOrder
                        },
                        new BookingStatus
                        {
                            Id = x.Status.Id,
                            Status = x.Status.Status
                        })
                )