Que: Query alternative to the following SQL code in LINQ is ____________

SELECT TOP 10 UPPER (c1.Name)
FROM Customer c1
WHERE
   c1.Name LIKE 'A%'
   AND c1.ID NOT IN
   (
      SELECT TOP 20 c2.ID
      FROM Customer c2
      WHERE c2.Name LIKE 'A%'
      ORDER BY c2.Name
   ) 
ORDER BY c1.Name
a. var query =FROM c IN db.CustomersWHERE c.Name.EndsWith (“A”)orderby c.NameSELECT c.Name.ToUpper();var thirdPage = query.Skip(20).Take(10);
b. var query =FROM c IN db.CustomersWHERE c.Name.StartsWith (“65”)orderby c.NameSELECT c.Name.ToUpper();var thirdPage = query.Skip(20).Take(10);
c. var query =FROM c IN db.CustomersWHERE c.Name.StartsWith (“A”)orderby c.NameSELECT c.Name.ToUpper();var thirdPage = query.Skip(20).Take(10);
d. var query =FROM c IN db.CustomersWHERE c.Name.StartsWith (“A”)orderby c.NameSELECT c.Name.ToLower();var thirdPage = query.Skip(20).Take(10);
Answer: var query =FROM c IN db.CustomersWHERE c.Name.StartsWith (“A”)orderby c.NameSELECT c.Name.ToUpper();var thirdPage = query.Skip(20).Take(10);

Leave a Comment