Join Query Error

[bryan costanich]

Hi all,

When i run a join query, like the following example:

var dbItems =
(from a in db.Orders
from b in db.OrderSections
from c in db.Tickets
where a.Order1 == b.Order
where b.OrderSection1 == c.OrderSection
where c.Event == eventID
select a);

i get the following run-time error:

Argument type 'DbLinq.Data.Linq.Table`1
[TixSmart.BoxOffice.Local.DL.OrderSection]' does not match the
corresponding member type 'TixSmart.BoxOffice.Local.DL.OrderSection'

it's happening at NewExpressionMutator line 48.

i've tried this on a couple different queries that look similar and
they're all getting the same error (the types are different, but the
message is the same).

has anyone seen this?

[bryan costanich]

Pascal,

Per our IM conversation, I created a repro for this and e-mailed it to
you.

-b