Que: LINQ query to retrieve a selection of customers, each with their high-value purchases is _____________

a. FROM c IN db.CustomersWHERE c.Address.State == “WA”SELECT NEW{c.Name,c.CustomerNumber,HighValuePurchases = c.Purchases.Where (p => p.Price > 1000)}
b. FROM c IN db.CustomersWHERE c.Address.State = “WA”SELECT NEW{c.Name,c.CustomerNumber,HighValuePurchases = c.Purchases.Where (p => p.Price > 1000)}
c. FROM c IN db.CustomersWHERE c.Address.State == “WA”SELECT NEW{c.Name,c.CustomerNumber,HighValuePurchases != c.Purchases.Where (p => p.Price > 1000)}
d. All of the mentioned
Answer: FROM c IN db.CustomersWHERE c.Address.State == “WA”SELECT NEW{c.Name,c.CustomerNumber,HighValuePurchases = c.Purchases.Where (p => p.Price > 1000)}

Leave a Comment