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:

PLC

Programmable Logic Controller; a digital computer used for automation of electromechanical processes, such as control of machinery on factory assembly lines.

Memory Area

A specific location within a computer or device storage where data is kept for retrieval and manipulation.

Computer

Any electronic device that can accept information, manipulate it according to a set of preprogrammed instructions, and supply the results of the manipulation.

Files

Digital documents or records stored in a computer system or other storage devices.