- Which LINQ code can be used to extract customers that have made sales of over 5,000 dollars and whose name starts with A?
- FROM p IN db.Purchases
WHERE p.Customer.Name.StartsWith("A")
WHERE p.PurchaseItems.Sum (pi => pi.SaleAmount) = 5000
SELECT p
- FROM p IN db.Purchases
WHERE p.Customer.Name.StartsWith("A")
WHERE p.PurchaseItems.Sum (pi => pi.SaleAmount) > 5000
SELECT p
- FROM p IN db.Purchases
WHERE p.Customer.Name.EndsWith("A")
WHERE p.PurchaseItems.Sum (pi => pi.SaleAmount) < 1000
SELECT p
- FROM p IN db.Purchases
WHERE p.Customer.Name.StartsWith("A")
WHERE p.PurchaseItems.Sum (pi => pi.SaleAmount) >= 1000
SELECT p
- Which of the following statements in regards to LINQ is incorrect?
- Compared to languages such as SQL, LINQ is more complex to code.
- LINQ supports Join.
- LINQ can be used to do operations on XML files.
- All of the above.
- Which of the following supports LINQ queries?
- Object Collection
- Entity Framework
- XML Document
- 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.