TABLE OF CONTENTS |
 |
LINQ to DataSet |
LINQ to DataSet refers to the implementation of LINQ that works with relational data. It falls under the umbrella of LINQ to ADO.NET that also includes LINQ to SQL, which was covered in the previous section of this learning guide, and LINQ to Entities, which is next. Additional insight on the umbrella that is LINQ to ADO.NET is available on MSDN.) Here we offer a set of tips and tutorials for LINQ to DataSet programming.
LINQ to DataSet overview
(Microsoft)
This brief introduction explains how LINQ to DataSet fits into the ADO.NET programming model and
how it can be used for n-tier applications.
LINQ to DataSet Programming
Guide (Microsoft)
Here you'll find resources that explain key LINQ to DataSet concepts such as comparing DataRows,
creating DataTables, data binding and debugging.
Video: LINQ to DataSet
(Microsoft)
Here Daniel Moth explains the ins and outs of LINQ to DataSet. This assumes some prior knowledge of
how LINQ to Objects works.
LINQ to Dataset
introduction (Daniel Moth)
This article looks at the three types within the System.Data.DataSetExtensions.dll assembly -- and
they are DataRowExtensions, DataTableExtensions and TypedTableBaseExtensions -- that are most
important to LINQ to DataSet.
Rich query for DataSet: An
introduction to LINQ to DataSet (CoDe Magazine)
Here Andrew Conrad, one of the core designers of LINQ, explains some interesting LINQ to DataSet
features. For example, there's a Field
Querying
DataSets: Introducing LINQ to DataSet (ADO.NET team blog)
In the first of a three-part series by the ADO.NET team at Microsoft, Erick Thompson demonstrates
how LINQ to DataSet improves on the sort of queries one had to perform in ADO.NET 2.0.
Type
safety: LINQ to DataSets Part 2 (ADO.NET team blog)
Here Thompson explains the aforementioned Field
Nulls:
LINQ to DataSets Part 3 (ADO.NET team blog)
Here Thompson explains how the Null in LINQ is used quite differently than the Null in SQL.
LINQ to DataSet samples: Visual
Basic (Microsoft)
This page provides 101 samples, arranged in categories such as Aggregate Operators, Ordering
Operators, Restriction Operators and more. (It does not appear as though a similar set of samples
is available for C#. Sorry, folks.)
Book Excerpt: Working with
LINQ and DataSets from LINQ in Action
This chapter comes from Manning Publications' LINQ in Action by Fabrice Marguerie, Steve
Eichert and Jim Wooley. It focuses on both typed and untyped DataSets.
Data
binding with LINQ to DataSet and Data
binding with LINQ to DataSet and LINQDataView (Erick Thompson)
This article explains what programmers can do if the basic data binding features of LINQ to DataSet
are not enough. The best option, as Thompson suggests in the second post here, is the
LinqDataView.
*** Go on to the next section of the LINQ Learning Guide: LINQ to Entities
This was first published in February 2008