Questions

1. Which LINQ code can be used to extract customers that have made sales of over 5,000 dollars and whose name starts with A?
   1. FROM p IN db.Purchases
      WHERE p.Customer.Name.StartsWith("A")
      WHERE p.PurchaseItems.Sum (pi => pi.SaleAmount) = 5000
      SELECT p
   2. FROM p IN db.Purchases
      WHERE p.Customer.Name.StartsWith("A")
      WHERE p.PurchaseItems.Sum (pi => pi.SaleAmount) > 5000
      SELECT p
   3. FROM p IN db.Purchases
      WHERE p.Customer.Name.EndsWith("A")
      WHERE p.PurchaseItems.Sum (pi => pi.SaleAmount) < 1000
      SELECT p
   4. FROM p IN db.Purchases
      WHERE p.Customer.Name.StartsWith("A")
      WHERE p.PurchaseItems.Sum (pi => pi.SaleAmount) >= 1000
      SELECT p

2. Which of the following statements in regards to LINQ is incorrect?
   1. Compared to languages such as SQL, LINQ is more complex to code.
   2. LINQ supports Join.
   3. LINQ can be used to do operations on XML files...