VirgilReality
❔ Need help with a linq query
This seems logically off: "where product.ProductName == order.OrderName "
Why would a product's Name and an order's Name be the same value? I don't know how your data is organized, but I'd expect an OrderItem table to join Order and Product on IDs.
Find your primary keys for those tables, and you'll have your answer.
6 replies