Request for LINQ query

Question

I have a sql query. Please someone help me to convert it into LINQ.

select * from ProductOrder where OrderId != (Select OrderId from OrderEvents) and MemberId=2

I write this code. But tis is not working. please help me.

                              from order in db.ProductOrder
                              from cancel in db.OrderEvents
                              where order.MemberId == MemberId 
                              where order.OrderId != cancel.OrderId 
                              //orderby order.OrderId descending 
                              select order

You missed my point. You need to show what you have already tried. At least demonstrate some effort. Stack Overflow is not here to write code for you. — Jon B, Apr 18 '14 at 13:51

score 0 · Answer 1 · answered Apr 18 '14 at 13:14

0

ProductOrder.Where(x=>x.OrderId != OrderEvents.OrderId && x.MemberId ==2)

answered Apr 18 '14 at 13:14

Maximc

1,722
1
23
37

Request for LINQ query

1 Answers1