query error

[bryan costanich]

Hi all,

i tried using the following query today with DbLinq:

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

and i get the error:

Could not find an implementation of the query pattern for source type
'DbLinq.Data.Linq.Table<TixSmart.BoxOffice.Local.DL.Order>'.
'SelectMany' not found. Are you missing a reference to
'System.Core.dll' or a using directive for 'System.Linq'?

i have a reference to DbLinq and DbLinq.MySql, and a working linq
classes of my database that i created in dbmetal or whatever.

what am i missing?

[Pascal Craponne]

using System.Linq;

[bryan costanich]

oy, that was stupid. :(

i thought i needed a different reference for dblinq. hahaha

thanks pascal.

On Dec 3, 12:58 am, "Pascal Craponne" <pic...@gmail.com> wrote:
> using System.Linq;

[bryan costanich]

ok, i'm getting the following run-time error from it:

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.