Select from following answers:- var q = from c in categories join p in products on c.CategoryID equals p.CategoryID where c.CategoryName == "Beverage" select p.ProductName;

- var q = from c in categories join p in products on c.CategoryID equals p.CategoryID select p.ProductName == "Beverage";
- var q = from c in categories join p in products on c.CategoryID equals p.CategoryID select c.CategoryName == "Beverage";
- All Above
Use a LINQ expression with a join and the given where clause to get the list of product names that are in the beverage category.
This expression returns a list of category names, not product names as is required:
var q = from c in categories
join p in products on c.CategoryID equals p.CategoryID
where p.ProductName == "Beverage"
select c.CategoryName;
Show Correct Answer
Source: MeasureUp.Com | |
Alert Moderator