Please, accept our apologies. You have encountered an issue with our implementation for multiple joins in queries written in Visual Basic. We will be working on fixing this as soon as possible. For the time being, there may be a way to rewrite the query so that joins are simulated. If you have associations in your persistent classes and you can navigate from the AmericanPropAddress
in a similar way to this AmericanPropAddress.PropertyAddressAssoc.GeographicLocation.ExchangeService
, then you can use that approach instead of the join. You may need to start the selection from the persistent type which is involved in the many side of an association so that you traverse the one-side navigation properties. To illustrate this point, suppose that we have orders, for every order there is one customer and we have many order details. Then an example query which mimics a join and starts the selection from the many side would be:
query = From orderDetail
, orderDetail.Order.Customer.CompanyName) _
If you can give us the structure of your persistent model we can tell you whether there is a workaround query that accomplishes the same result.
We do hope the provided information was helpful. Again, we apologize for the inconvenience caused.
the Telerik team