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
  1. 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.
    4. All of the above.
  1. Which of the following supports LINQ queries?
    1. Object Collection
    2. Entity Framework
    3. XML Document
    4. All of the above
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.119.106.237