|
|||||||||||||||||||||
|
|||||||||||||||||||||
|
Announcements
Chapters
Services
Feature Zones
|
IntroductionThis article provides an introduction to employing LINQ to Objects queries to support a simple WinForms application; the article addresses the construction of LINQ to Objects statements, and then goes on to describe how one might use LINQ to Objects within the context of an actual application. The demonstration project included with the article is a simple contact manager which may be used to capture and store information about a person’s contacts in address book format. This demonstration application uses LINQ to Objects to manage, query, and order the list of contacts maintained by the application. The demonstration application also includes a dummy contact file with a collection of test contacts.
Figure 1: Application Main Form
The application provides the following functionality:
Naturally, the approaches used within the application are representative of only one way of doing things; as with most things in the .NET world, there are several alternatives, and you can modify the code to work with the data using one of the other alternatives, if you prefer to do so.
Figure 2: Searching for a Contact by Last Name
Figure 3: Listing All Contacts (Edits to the grid are posted immediately to the List)
Figure 4: Rolodex Function
LINQ to Objects StatementsThis section will discuss some of the common techniques used in LINQ to Objects statement construction. In a nutshell, LINQ to Objects provides the developer with the means to conduct queries against an in-memory collection of objects. The techniques used to query against such collections of objects are similar to but simpler than the approaches used to conduct queries against a relational database using SQL statements. Anatomy of LINQ to Objects StatementsExample 1 – A Simple SelectThis is an example of a very simple LINQ to Objects statement: Public Sub Example1()
Dim tools() As String = {"Tablesaw", "Bandsaw", "Planer", "Jointer", _
"Drill", "Sander"}
Dim List = From t In tools _
Select t
Dim sb As New StringBuilder()
Dim s As String
For Each s In List
sb.Append(s + Environment.NewLine)
Next
MessageBox.Show(sb.ToString(), "Tools")
End Sub
In the example, an array of strings ( Dim List = From t In tools _
Select t
In this example, an untyped variable “ If you were to create a project, add this bit of code to a method, and run it; the results would look like this:
Figure 5: Query Results
Example 2 – Select with a Where ClauseThe next example shows a LINQ to Objects query that incorporates a Public Sub Example2()
Dim Birds() As String = {"Indigo Bunting", "Rose Breasted Grosbeak", _
"Robin", "House Finch", "Gold Finch", _
"Ruby Throated Hummingbird", _
"Rufous Hummingbird", "Downy Woodpecker"}
Dim list = From b In Birds _
Where b.StartsWith("R") _
Select b
Dim sb As New StringBuilder()
Dim s As String
For Each s In list
sb.Append(s + Environment.NewLine)
Next
MessageBox.Show(sb.ToString(), "R Birds")
End Sub
If you were to run this query, the results would appear as follows (all birds with names beginning with the letter “R” are shown):
Figure 6: R Birds Query Results
Example 3 – Select with a Where ClauseIn a slight variation to the previous query, this example looks for an exact match in its Public Sub Example3()
Dim Birds() As String = {"Indigo Bunting", "Rose Breasted Grosbeak", _
"Robin", "House Finch", "Gold Finch", _
"Ruby Throated Hummingbird", _
"Rufous Hummingbird", "Downy Woodpecker"}
Dim list = From b In Birds _
Where b = "Indigo Bunting" _
Select b
Dim sb As New StringBuilder()
Dim s As String
For Each s In list
sb.Append(s + Environment.NewLine)
Next
MessageBox.Show(sb.ToString(), "Bunting Birds")
End Sub
Running this code will result in the display of this message box:
Figure 7: Bird Query Results
Example 4 – Generating an Ordered ListIn this query, the list of birds is alphabetized (using “ Public Sub Example4()
Dim Birds() As String = {"Indigo Bunting", "Rose Breasted Grosbeak", _
"Robin", "House Finch", "Gold Finch", _
"Ruby Throated Hummingbird", _
"Rufous Hummingbird", "Downy Woodpecker"}
Dim list = From b In Birds _
Order By b Ascending _
Select b
Dim sb As New StringBuilder()
Dim s As String
For Each s In list
sb.Append(s + Environment.NewLine)
Next
MessageBox.Show(sb.ToString(), "Ordered Birds")
End Sub
Figure 8: Ordered Bird List Query Results
Example 5 – Working with a Custom TypeIn this example, a typed list is created, populated, and then queried using LINQ to Objects. Public Sub Example5()
Dim parts = New List(Of Parts)
Dim p1 As New Parts()
p1.PartNumber = 1
p1.PartDescription = "Cog"
parts.Add(p1)
Dim p2 As New Parts()
p2.PartNumber = 2
p2.PartDescription = "Widget"
parts.Add(p2)
Dim p3 As New Parts()
p3.PartNumber = 3
p3.PartDescription = "Gear"
parts.Add(p3)
Dim p4 As New Parts()
p4.PartNumber = 4
p4.PartDescription = "Tank"
parts.Add(p4)
Dim p5 = New Parts()
p5.PartNumber = 5
p5.PartDescription = "Piston"
parts.Add(p5)
Dim p6 As New Parts()
p6.PartNumber = 6
p6.PartDescription = "Shaft"
parts.Add(p6)
Dim p7 As New Parts()
p7.PartNumber = 7
p7.PartDescription = "Pulley"
parts.Add(p7)
Dim p8 As New Parts()
p8.PartNumber = 8
p8.PartDescription = "Sprocket"
parts.Add(p8)
Dim list = From p In parts _
Order By p.PartNumber Ascending _
Select p
Dim sb As New StringBuilder()
Dim pt As Parts
For Each pt In parts
sb.Append(pt.PartNumber.ToString() + ": " + _
pt.PartDescription.ToString() + _
Environment.NewLine)
Next
MessageBox.Show(sb.ToString(), "Parts List")
End Sub
The purpose of the query is merely to sort the parts list in the order of the part numbers. The results returned from this method are as follows:
Figure 9: Ordered Parts List Query
The Public Class Parts
Private mPartNumber As Integer
Private mPartDescription As String
Public Sub New()
' nothing
End Sub
Public Sub New(ByVal partNum As Integer, ByVal partDesc As String)
mPartNumber = partNum
mPartDescription = partDesc
End Sub
Public Property PartNumber() As Integer
Get
Return mPartNumber
End Get
Set(ByVal value As Integer)
mPartNumber = value
End Set
End Property
Public Property PartDescription() As String
Get
Return mPartDescription
End Get
Set(ByVal value As String)
mPartDescription = value
End Set
End Property
End Class
Example 6 – Searching a Typed List Using LINQ to ObjectsIn this example, a typed list is created (as in the previous example), populated, and then queried using LINQ to Objects. In this case, the query includes a Dim list = From p In parts _
Where p.PartDescription.StartsWith("S") _
Order By p.PartNumber Ascending _
Select p
Dim sb As New StringBuilder()
Dim pt As Parts
For Each pt In list
sb.Append(pt.PartNumber.ToString() + ": " _
+ pt.PartDescription.ToString() + _
Environment.NewLine)
Next
MessageBox.Show(sb.ToString(), "Parts List")
Figure 10: Matching Parts Query Results
Example 7 – Searching a Typed List Using LINQ to Objects and Returning a Single ResultIn this example, a typed list is created (as in the previous example), populated, and then queried using LINQ to Objects. In this case, a single result of type “ Dim matchingPart = (From m In list _
Where m.PartNumber.Equals(5) _
Select m).Single()
MessageBox.Show(matchingPart.PartDescription, "Matching Part")
The results of this query are shown in the next figure.
Figure 11: Returning a Single Result
The preceding examples were intended to provide a simple overview as to how to conduct some basic queries against collections using LINQ to Objects; there are certainly a great number of more complex operations that can be executed using similar procedures (grouping, joins, and selects into a new custom type, etc.). Getting StartedThere is a single solution included with this download, the solution contains a WinForms project called “LinqToObjectsVB”; this project contains two forms (the main form ( If you open the attached project into Visual Studio 2008, you should see the following in the Solution Explorer:
Figure 12: Solution Explorer
Code: Contact.vbThe The class begins with the normal and default imports: Imports System
Imports System.Collections.Generic
Imports System.Linq
Imports System.Text
The next section contains the class declaration. Note that the class is declared as serializable; the <Serializable()> _
Public Class Contact
The region defined in the class declares the member variables used internally by the class; member variables exposed externally are made accessible through public properties. #Region "Member Variables"
Private mId As System.Guid
Private mFirstName As String
Private mMiddleName As String
Private mLastName As String
Private mStreet As String
Private mCity As String
Private mState As String
Private mZip As String
Private mEmail As String
Private mHousePhone As String
Private mWorkPhone As String
Private mCellPhone As String
Private mFax As String
#End Region
The next region of code in the class contains the constructors. Two constructors are defined. A default constructor creates a new instance of the class and assigns it an internal ID (as a GUID). The second constructor accepts an ID as an argument, and sets the contact’s internal ID to that value. #Region "Constructor"
Public Sub New()
mId = Guid.NewGuid()
End Sub
Public Sub New(ByVal ID As System.Guid)
mId = ID
End Sub
#End Region
The last bit of code in this class is contained within the Properties region; this region contains all of the properties defined to access the member variables. Note that since the ID value is always set by the constructor, the property does not provide a public interface to set the GUID to a new value. #Region "Properties"
Public Property FirstName() As String
Get
Return mFirstName
End Get
Set(ByVal value As String)
mFirstName = value
End Set
End Property
Public Property MiddleName() As String
Get
Return mMiddleName
End Get
Set(ByVal value As String)
mMiddleName = value
End Set
End Property
Public Property LastName() As String
Get
Return mLastName
End Get
Set(ByVal value As String)
mLastName = value
End Set
End Property
Public Property Street() As String
Get
Return mStreet
End Get
Set(ByVal value As String)
mStreet = value
End Set
End Property
Public Property City() As String
Get
Return mCity
End Get
Set(ByVal value As String)
mCity = value
End Set
End Property
Public Property State() As String
Get
Return mState
End Get
Set(ByVal value As String)
mState = value
End Set
End Property
Public Property ZipCode() As String
Get
Return mZip
End Get
Set(ByVal value As String)
mZip = value
End Set
End Property
Public Property Email() As String
Get
Return mEmail
End Get
Set(ByVal value As String)
mEmail = value
End Set
End Property
Public Property HousePhone() As String
Get
Return mHousePhone
End Get
Set(ByVal value As String)
mHousePhone = value
End Set
End Property
Public Property WorkPhone() As String
Get
Return mWorkPhone
End Get
Set(ByVal value As String)
mWorkPhone = value
End Set
End Property
Public Property CellPhone() As String
Get
Return mCellPhone
End Get
Set(ByVal value As String)
mCellPhone = value
End Set
End Property
Public Property Fax() As String
Get
Return mFax
End Get
Set(ByVal value As String)
mFax = value
End Set
End Property
#End Region
End Class
That concludes the description of the ‘ Code: Main Application Form (frmContactBook.vb)The is the main form of the application; much of the code provides the framework for the application, and does not really pertain to LINQ to Objects. However, all of the code will be described herein to provide a proper context. The contact application’s main form contains the following controls:
Figure 13: frmContactBook.vb
The class begins with the normal and default imports: Imports System
Imports System.Collections.Generic
Imports System.ComponentModel
Imports System.Data
Imports System.Drawing
Imports System.Linq
Imports System.Text
Imports System.Windows.Forms
The next section contains the class declaration. Public Class frmContactBook
The next region defined in the class declares the member variables used internally by the class; member variables exposed externally are made accessible through public properties. The comment adjacent to each declaration describes its purpose. #Region "Member Variables"
Private contacts As New List(Of Contact) ' create a typed list of contacts
Private currentContact As Contact ' create a single contact instance
Private currentPosition As Integer ' used to hold current position
Private currentFilePath As String ' file path to current contact file
Private dirtyForm As Boolean ' keep track of dirty forms
#End Region
The next region of code in the class contains the constructor. Upon initialization, the application creates a new contact data list, creates a new contact data object, sets the current position indicator to zero, and sets the #Region "Constructor"
''' <summary>
''' Constructor - create a new instance of
''' the contact list and setup the local
''' member variables
''' </summary>
''' <remarks></remarks>
Public Sub New()
' This call is required by the Windows Form Designer.
InitializeComponent()
' Add any initialization after the InitializeComponent() call.
contacts = New List(Of Contact)
currentContact = New Contact()
contacts.Add(currentContact)
currentPosition = 0
dirtyForm = False
End Sub
#End Region
The next code region is called ‘Toolstrip Event Handlers’; the first event handler in this region is the #Region "Toolstrip Event Handlers"
''' <summary>
''' Add a new contact to the current contact list
''' </summary>
''' <param name="sender"></param>
''' <param name="e"></param>
''' <remarks></remarks>
Private Sub tsbAddRecord_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) _
Handles tsbAddRecord.Click
Me.addToolStripMenuItem_Click(Me, New EventArgs())
End Sub
The next ''' <summary>
''' Remove the current contact from the contact list
''' </summary>
''' <param name="sender"></param>
''' <param name="e"></param>
''' <remarks></remarks>
Private Sub tsbRemoveRecord_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) _
Handles tsbRemoveRecord.Click
Me.removeToolStripMenuItem_Click(Me, New EventArgs())
End Sub
The next handler is used to search for a specific contact using the contact’s last name. The code uses a LINQ to Objects query in order to find the first instance of a matching contact with that last name. The handler uses the Search Term text box control on the toolstrip to capture the last name, and it uses the Search button to execute the search. The code is annotated to describe what is going on in this method. ''' <summary>
''' Find a contact by searching the list
''' for a matching last name
''' </summary>
''' <param name="sender"></param>
''' <param name="e"></param>
''' <remarks></remarks>
Private Sub tsbFindContact_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) _
Handles tsbFindContact.Click
' return if the search term was not provided
If (String.IsNullOrEmpty(tspSearchTerm.Text)) Then
MessageBox.Show("Enter a last name in the space proved.", _
"Missing Search Term")
Return
End If
Try
' using linq to objects query to get first matching name
Dim foundGuy = _
(From contact In contacts _
Where contact.LastName = tspSearchTerm.Text _
Select contact).FirstOrDefault()
' set the current contact to the found contact
currentContact = foundGuy
currentPosition = contacts.IndexOf(currentContact)
' update the display by loading the
' found contact
LoadCurrentContact()
' clear the search term textbox and return
tspSearchTerm.Text = String.Empty
Return
Catch
MessageBox.Show("No matches were found", "Search Complete")
End Try
End Sub
The next handler saves the current contact list; this handler just calls the matching menu ''' <summary>
''' Save the current contact list
''' </summary>
''' <param name="sender"></param>
''' <param name="e"></param>
''' <remarks></remarks>
Private Sub tsbSave_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) _
Handles tsbSave.Click
Me.saveStripMenuItem_Click(Me, New EventArgs())
End Sub
The next handler is used to navigate back one contact from the current position of the displayed contact. If the contact as at the lower limit, the button click is ignored. ''' <summary>
''' Navigate back to the previous record
''' if not at the lower limit
''' </summary>
''' <param name="sender"></param>
''' <param name="e"></param>
''' <remarks></remarks>
Private Sub tsbNavBack_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) _
Handles tsbNavBack.Click
' capture form changes and plug them
' into the current contact before
' navigating off the contact
SaveCurrentContact()
' don't exceed the left limit
If (currentPosition <> 0) Then
currentPosition -= 1
currentContact = contacts(currentPosition)
LoadCurrentContact()
End If
End Sub
The next handler is used to navigate forward one contact from the current position of the displayed contact. If the contact is at the upper limit, the button click is ignored. ''' <summary>
''' Navigate to the next record if
''' not at the upper limit
''' </summary>
''' <param name="sender"></param>
''' <param name="e"></param>
''' <remarks></remarks>
Private Sub tsbNavForward_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) _
Handles tsbNavForward.Click
' capture form changes and plug them
' into the current contact before
' navigating off the contact
SaveCurrentContact()
' don't exceed the right limit
If (currentPosition < contacts.Count - 1) Then
currentPosition += 1
currentContact = contacts(currentPosition)
LoadCurrentContact()
End If
End Sub
The next handler is used to exit the application. This handler merely calls the matching menu item ''' <summary>
''' Exit the application
''' </summary>
''' <param name="sender"></param>
''' <param name="e"></param>
''' <remarks></remarks>
Private Sub tsbExit_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) _
Handles tsbExit.Click
Me.exitToolStripMenuItem_Click(Me, New EventArgs())
End Sub
#End Region
The next region contains the menu item #Region "Menu Item Click Event Handler"
''' <summary>
''' Create a new contact list and clear
''' the contact form
''' </summary>
''' <param name="sender"></param>
''' <param name="e"></param>
''' <remarks></remarks>
Private Sub newToolStripMenuItem_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) _
Handles newToolStripMenuItem.Click
' check to see if the form has been editted
If dirtyForm = True Then
If (MessageBox.Show(Me, "You have not saved the current contact data; " + _
"would you like to save before starting a new " + _
"contact database?", "Save Current Data",
MessageBoxButtons.YesNo) = _
System.Windows.Forms.DialogResult.Yes) Then
' display the save dialog if the contact list is dirty
saveAsMenuItem_Click(Me, New EventArgs())
End If
Else
' discard the contact list and
' start new document
contacts = New List(Of Contact)
ClearScreen()
End If
End Sub
The next event handler is used to open a contacts file. Again, the handler checks for a dirty form and provides the user with an opportunity to save if the form is dirty. A separate ''' <summary>
''' Open an existing contact file
''' </summary>
''' <param name="sender"></param>
''' <param name="e"></param>
''' <remarks></remarks>
Private Sub openToolStripMenuItem_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) _
Handles openToolStripMenuItem.Click
' give the user an opportunity to save the current
' contact list if the data has been edited
If dirtyForm = True Then
If (MessageBox.Show(Me, "You have not saved the current contact data; " + _
"would you like to save before opening a different " + _
"contact database?", "Save Current Data",
MessageBoxButtons.YesNo) = _
System.Windows.Forms.DialogResult.Yes) Then
saveAsMenuItem_Click(Me, New EventArgs())
End If
Else
' call the open function to open the file
Open()
End If
End Sub
The Save menu item is used to save the current contacts file to disk; the function first calls a “ ''' <summary>
''' Save the current contact list
''' </summary>
''' <param name="sender"></param>
''' <param name="e"></param>
''' <remarks></remarks>
Private Sub saveStripMenuItem_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) _
Handles saveStripMenuItem.Click
' save the current form data to the list
SaveCurrentContact()
' if the file path is not set, open the
' save file dialog
If String.IsNullOrEmpty(currentFilePath) Then
Dim SaveFileDialog1 As New SaveFileDialog()
Try
SaveFileDialog1.Title = "Save CON Document"
SaveFileDialog1.Filter = "CON Documents (*.con)|*.con"
If (SaveFileDialog1.ShowDialog() = _
System.Windows.Forms.DialogResult.Cancel) Then
Return
End If
Catch
Return
End Try
currentFilePath = SaveFileDialog1.FileName
End If
' make sure the file path is not empty
If String.IsNullOrEmpty(currentFilePath) Then
Return
End If
' persist the contacts file to disk
Serializer.Serialize(currentFilePath, contacts)
' tell the user the file was saved
MessageBox.Show("File " + currentFilePath + " saved.", "File Saved.")
' everything is saved, set the dirtyform
' boolean to false
dirtyForm = False
End Sub
The next bit of code is used to support the “Save As” menu item; the call is similar to the previous Save method, but straight opens the Save File Dialog to permit the user to name or rename the file. ''' <summary>
''' Save the current contact data as a file
''' under a new name
''' </summary>
''' <param name="sender"></param>
''' <param name="e"></param>
''' <remarks></remarks>
Private Sub saveAsMenuItem_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) _
Handles saveAsMenuItem.Click
' save the current form data to the contact list
SaveCurrentContact()
' create and show the save file dialog
Dim SaveFileDialog1 As New SaveFileDialog()
Try
SaveFileDialog1.Title = "Save CON Document As"
SaveFileDialog1.Filter = "CON Documents (*.con)|*.con"
If (SaveFileDialog1.ShowDialog() = _
System.Windows.Forms.DialogResult.Cancel) Then
Return
End If
Catch
Return
End Try
currentFilePath = SaveFileDialog1.FileName
' make sure the file path is set
If String.IsNullOrEmpty(currentFilePath) Then
Return
End If
' persist the contacts file to disk
Serializer.Serialize(currentFilePath, contacts)
' tell the user the file was saved
MessageBox.Show("File " + currentFilePath + " saved.", "File Saved.")
' everything is saved, set the dirtyform
' boolean to false
dirtyForm = False
End Sub
The next method exits the application but checks the ''' <summary>
''' Exit the application
''' </summary>
''' <param name="sender"></param>
''' <param name="e"></param>
''' <remarks></remarks>
Private Sub exitToolStripMenuItem_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) _
Handles exitToolStripMenuItem.Click
If dirtyForm = True Then
If (MessageBox.Show(Me, "You have not saved the current contact data; " + _
"would you like to save before exiting?", "Save Current
Data", _
MessageBoxButtons.YesNo) =
System.Windows.Forms.DialogResult.Yes) Then
tsbSave_Click(Me, New EventArgs())
End If
Else
Application.Exit()
End If
End Sub
The next method is used to add a new contact to the current list of contacts; this method saves the current contact to the open list of contacts, creates a new contact, and adds it to the list of contacts, clears the form, and marks the form as dirty: ''' <summary>
''' Add a new contact to the current
''' contact list
''' </summary>
''' <param name="sender"></param>
''' <param name="e"></param>
''' <remarks></remarks>
Private Sub addToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles addToolStripMenuItem.Click
SaveCurrentContact()
currentContact = New Contact()
contacts.Add(currentContact)
ClearScreen()
dirtyForm = True
End Sub
The next method removes the current contact from the list and updates the display. ''' <summary>
''' Remove the current contact from the
''' contact list and update the display
''' </summary>
''' <param name="sender"></param>
''' <param name="e"></param>
''' <remarks></remarks>
Private Sub removeToolStripMenuItem_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) _
Handles removeToolStripMenuItem.Click
' make sure there are records
If contacts.Count = 0 Then
' remove the current record
contacts.Remove(currentContact)
' check to see if the current
' position is at the limit
' and move up or down
' as required
If (currentPosition = 0) Then
currentPosition += 1
End | ||||||||||||||||||||