Question: The tblBooks table contains five fields. The BookNum, Price, and QuantityInStock fields are numeric; the Title and Author fields contain text. The datasets name is
The tblBooks table contains five fields. The BookNum, Price, and QuantityInStock fields are numeric; the Title and Author fields contain text. The dataset’s name is BooksDataSet.
a. Write a LINQ statement that arranges the records in ascending order by the Author field.
b. Write a LINQ statement that selects records having a price of at least $12.75.
c. Write a LINQ statement that selects records having more than 100 books in inventory.
d. Write a LINQ statement that selects the books written by George Marten and arranges the books in descending order by the book’s price.
Step by Step Solution
3.34 Rating (160 Votes )
There are 3 Steps involved in it
a Dim records From book In BooksDataSettblBooks Order By bookAuthor Select bo... View full answer
Get step-by-step solutions from verified subject matter experts
Study Help