Valid SQL confuses Linqer 3.5.3

[jneave]

Hi,

SQL Server's View generator produces valid but badly laid out SQL.
This confuses Linqer, although rearranging it fixes the problem.

This doesn't work in Linqer:

SELECT DISTINCT CasePaymentArrangements.*
FROM            CasePaymentArrangementsRelatedCases
               INNER JOIN CasePaymentArrangementsSchedule
               INNER JOIN CasePaymentArrangements
               ON              CasePaymentArrangementsSchedule.RelatedPayArrID     = CasePaymentArrangements.PayArrID
               ON              CasePaymentArrangementsRelatedCases.RelatedPayArrID = CasePaymentArrangements.PayArrID

The error is:

SQL cannot be converted to LINQ: Field [CasePaymentArrangements.PayArrID ON CasePaymentArrangementsRelatedCases].[RelatedPayArrID = CasePaymentArrangements.PayArrID] not found in the current Data Context.

But this does, although it's functionally identical:

SELECT DISTINCT CasePaymentArrangements.*
FROM            CasePaymentArrangementsRelatedCases
               INNER JOIN CasePaymentArrangements ON              CasePaymentArrangementsRelatedCases.RelatedPayArrID = CasePaymentArrangements.PayArrID
               INNER JOIN CasePaymentArrangementsSchedule ON              CasePaymentArrangementsSchedule.RelatedPayArrID     = CasePaymentArrangements.PayArrID
             

Regards,

James.

[Mikhail Oumantsev]

Thank you James.
This is a bug.
I will put it in my to do list.

Mikhail.