Invalid Linq query using Where

Question

I have the following code:

    public ActionResult Details(int orderId)
    {
        var query = from orderDetails in storeDb.OrderDetails
                    where orderDetails.OrderId = orderId
                    select new { orderDetails.Product, orderDetails.Quantity, orderDetails.UnitPrice };

        return View(query);
    }

I want to get the rows of orderDetails where the foreign key OrderId is equal to the parameter orderId. However I keep getting the following error: Error 2 Cannot implicitly convert type 'int' to 'bool'. What am I missing?

Marlon · Accepted Answer · 2012-04-17 05:19:43Z

8

where orderDetails.OrderId = orderId

Needs to be

where orderDetails.OrderId == orderId

edited Apr 17, 2012 at 5:19

answered Jul 24, 2011 at 4:59

Marlon

20.3k14 gold badges77 silver badges106 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

m4tt1mus Over a year ago

@Seth since this is the right answer you should mark it as the answer.

sloth · Accepted Answer · 2012-08-06 08:28:09Z

0

where orderDetails.OrderId == orderId

edited Aug 6, 2012 at 8:28

sloth

101k21 gold badges182 silver badges224 bronze badges

answered Jul 24, 2011 at 5:01

Kenneth J

4,89612 gold badges43 silver badges56 bronze badges

Collectives™ on Stack Overflow

Invalid Linq query using Where

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related