Visual Basic 2015 Unleashed

Querying DataSets with LINQ

LINQ to DataSets is the standard LINQ provider for querying DataSets and is offered by the System.DataSet.DataSetExtensions namespace. Querying means that LINQ can only get information for DataSets but not for manipulating them. If you need to add, remove, replace, or persist data versus DataSets, you need to use old-fashioned techniques. Instead you can improve getting information using LINQ. You typically use DataSets in Windows client applications such as Windows Forms and WPF. This chapter shows you code within a Console application for demonstration purposes. To complete the proposed examples, follow these steps:

Create a new Console application and name the project LinqToDataSets.

Establish a connection to ...