score:0

string productname = "sugar";

// keep only the orders that have at least one product with name "sugar"
var orderswithsugar = queryorderswiththeirproducts
    .where(order => order.products.where(product => product.name == productname)
                         .any());

Related Query

More Query from same tag