Joins...

I'm a bit baffled on this one.  I wrote it to simplify it and use NorthwindIB.  Pretend we just didn't have a FK between Orders and OrderDetails.  (I've tried a couple different join methods and all result with the same problem).

If I do the following with Silverlight:

    public MainPage()
    {
      InitializeComponent();

      DomainModelEntityManager mgr = new DomainModelEntityManager();

      int i = 1;
      var q1 = from o in mgr.Orders
               join d in mgr.OrderDetails
                 on new { o.OrderID } equals new { d.OrderID }
               where (d.Quantity > i)
               select o;

      mgr.ExecuteQueryAsync(q1, callback, null);
    }

    public void callback(EntityFetchedEventArgs<Order> args)
    {
      if (args.Error != null)
        MessageBox.Show(args.Error.Message);
      else if (args.Result != null)
        MessageBox.Show(args.Result.ToString());
    }

The args.Error.Message says: "Attempt by method 'System.Linq.Expressions.Expression.CreateLambda(System.Type, System.Linq.Expressions.Expression, System.String, Boolean, System.Collections.ObjectModel.ReadOnlyCollection`1<System.Linq.Expressions.ParameterExpression>)' to access method 'System.Linq.Expressions.Expression`1<System.Func`2<<>f__AnonymousType0`2<DomainModel.Order,DomainModel.OrderDetail>,System.Boolean>>.Create(System.Linq.Expressions.Expression, System.String, Boolean, System.Collections.ObjectModel.ReadOnlyCollection`1<System.Linq.Expressions.ParameterExpression>)' failed."

However, the same code in a console app runs just fine.  The only difference is the WCF and of course the actual library code.  Any idea where the problem is?

Also... If I don't use a variable, it runs fine:  d.Quantity > 1

Thanks.

Yes, I tried quite a few join methods.  Anything with a variable fails in Silverlight but works fine in the .net library

      var q1 = from o in mgr.Orders
               join d in mgr.OrderDetails
                 on  o.OrderID equals d.OrderID
               where (d.Quantity > i)
               select o;

      var q1 = mgr.Orders
                  .Join(mgr.OrderDetails,
                        o => o.OrderID,
                        d => d.OrderID,
                        (o, d) => new { o = o, d = d })
                  .Where(r => r.d.Quantity > i)
                  .Select(r => r.o);