Question: c# (Querying an Array of Invoice Objects) Use the class Invoice provided in the ex09_03 folder with this chapters examples to create an array of

c# (Querying an Array of Invoice Objects) Use the class Invoice provided in the ex09_03 folder with this chapters examples to create an array of Invoice objects. Use the sample data shown in Fig. 9.8. Class Invoiceincludes four propertiesa PartNumber (type int), a PartDescription (type string), a Quantity of the item being purchased (type int) and a Price (type decimal). Perform the following queries on the array of Invoice objects and display the results:

Use LINQ to sort the Invoice objects by PartDescription.

Use LINQ to sort the Invoice objects by Price.

Use LINQ to select the PartDescription and Quantity and sort the results by Quantity.

Use LINQ to select from each Invoice the PartDescription and the value of the Invoice (i.e., Quantity * Price). Name the calculated column InvoiceTotal. Order the results by Invoice value. [Hint: Use let to store the result of Quantity * Price in a new range variable total.]

Using the results of the LINQ query in part (d), select the InvoiceTotals in the range $200 to $500.

c# (Querying an Array of Invoice Objects) Use the class Invoice provided

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!