Visual Studio LINQ program
CSC139 Chapter 11 Lab Assignments
Objectives
In this lab assignment, students will learn:
- How to define LINQ statement
- How to use LINQ to query data from object array
Goals
In this lab assignment, students will demonstrate the abilities to:
- Define LINQ statement
- Use LINQ to query data from object array
Grading rubric
| Category | High Proficiency | Medium Proficiency | Low Proficiency |
| Define the LINQ which get all scores in ascending order [40 pts] | Successfully define the LINQ which get all scores in ascending order. [40ts] | LINQ statement works, however, does not generate correct results. [20–39 pts] | LINQ statement is not defined correctly. [0-19 pts] |
| Define the LINQ which get all students who passed the exam [40 pts] | Successfully define the LINQ which get all students who passed the exam. [40ts] | LINQ statement works, however, does not generate correct results. [20-39 pts] | LINQ statement is not defined correctly. [0-19 pts] |
| Define the code to display the LINQ results correctly (20 pts) | Successfully define the code to display the LINQ results correctly. [20 pts] | The results can be displayed, however, some data or format are not correct. [10-19 pts] | Results can not be displayed, or most data or formats are not correct. [0-9 pts] |
Create a console application “LINQGradeBook”
Add the following class definition:
Public Class GradeBook
Private nameValue As String
Private scoreValue As Integer
Public Sub New(ByVal n As String, ByVal s As Integer)
nameValue = n
scoreValue = s
End Sub
Public Property Name() As String
Get
Return nameValue
End Get
Set(ByVal value As String)
nameValue = value
End Set
End Property
Public Property Score() As Integer
Get
Return scoreValue
End Get
Set(ByVal value As Integer)
scoreValue = value
End Set
End Property
Public Sub displayGradeBook()
Console.WriteLine("Name: " & Name & vbTab & "Score: " & Score)
End Sub
End Class
Rename the file “Module1.vb” to “LINQGradeBookTester.vb”
Complete the missing code following the comments. You are required to create two LINQ statements which will select specific gradeBook object from a GradeBook objects array.
Option Strict On
Module LINQGradeBookTester
Sub Main()
Dim g1 As New GradeBook("AAA", 70)
Dim g2 As New GradeBook("BBB", 50)
Dim g3 As New GradeBook("CCC", 100)
Dim g4 As New GradeBook("DDD", 80)
'add g1, g2, g3 and g4 in a array and display all student scores
Dim gradeBooks As GradeBook() = {g1, g2, g3, g4}
display(gradeBooks, "Scores for all students: ")
'create a LINQ which get all scores in ascending order and display them.
'create a LINQ which get all students who passed the exam
'display number of passed students, their names and scores
End Sub
'display gradeBook's information
Private Sub display(ByVal gradeBooks As IEnumerable, ByVal header As String)
Console.WriteLine(header)
For Each g As GradeBook In gradeBooks
g.displayGradeBook()
Next
Console.WriteLine()
End Sub
End Module
Here is output: (See next page)
