Lab Objective

Lab 1: LINQ Project: Unified Language Features for Object and Relational Queries

This lab provides an introduction to the LINQ Project. The language integrated query framework for .NET (“LINQ”) is a set of language extensions to C# and Visual Basic and a unified programming model that extends the .NET Framework to offer integrated querying for objects, databases, and XML.

In this lab, you will see how LINQ features can be used against in-memory collections, XML documents, and connected databases. The lab ends with an optional exercise that looks at the various standard query operators available for data manipulation and extraction.

This lab makes extensive use of new language features provided in C# 3.0. When first introduced they are pointed out; however for a more in depth understanding of how these features work, refer to the C# 3.0 Language Specification Hands On Lab.

Lab Objective

Estimated time to complete this lab: 60 minutes

The objective of this lab is to provide a clear understanding of the LINQ project. You will see how data manipulation can occur on objects in memory, XML files, datasets, and relational databases. The new LINQ APIs benefit from IntelliSense™ and full compile-time checking without resorting to string-based queries. This lab touches on basic LINQ technologies, along with database-specific LINQ to SQL, XML-specific LINQ to XML, and dataset-specific LINQ to DataSets. A brief look at query operators is also included.

This lab uses the Northwind database and consists of the following exercises:

Date: 2015-02-03; view: 780