Writing LINQ Statements The TblBicycle Table Contains Five Fields: ItemNum, ItemName, Color, Price

question 47

Essay

Writing LINQ Statements
The tblBicycle table contains five fields: ItemNum, ItemName, Color, Price, and Quantity. The Price and Quantity fields are numeric; all other fields are text. The dataset name is BicycleDataSet.
-Write a LINQ statement to select all blue bicycles.Order the bicycles in ascending order by quantity.

---

Definitions:

Direct Material Cost

The expense of basic materials and parts directly utilized in manufacturing a product.

Period Cost

Costs that are not directly tied to the production process and are expensed in the period in which they are incurred, such as selling, general, and administrative expenses.

Opportunity Cost

The cost of forgone alternatives when one option is chosen over another.

Administrative Expense

Costs related to the general operation and administration of a business, including salaries of executive personnel, office supplies, and utilities.