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

question 39

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 the code to calculate the average price of all of the bicycles in inventory.

---

Definitions:

Fair Values

The valuation received for disposing of an asset or the expense of moving a liability in an organized market activity on the assessment date.

Acquisition

The process of obtaining control of another corporation, purchasing its shares, or assets, to expand or diversify operations.

Voting Common Stock

Shares that give the shareholder voting rights in corporate decisions, typically one vote per share owned.

Preferred Stock

A class of ownership in a corporation with a fixed dividend that is paid out before any dividends to common stockholders.