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:

Production Sector

The segment of the economy involved in the production of goods and services.

Consumers Spend

Consumers spend refers to the total amount of money spent by households in an economy on goods and services over a period.

Dark Pools

Private financial forums or exchanges for trading securities, not accessible by the investing public.

Broker-Dealer Organizations

Broker-dealer organizations are financial institutions that buy and sell securities for their own accounts and on behalf of their customers, and often provide investment advice and related services.