This documentation is archived and is not being maintained.

LINQ to Northwind Sample

.NET Framework 3.5

The LINQ to Northwind sample is designed to support many of the scenarios demonstrated in the various LINQ samples.

To get samples and instructions for installing them

  • Do one or more of the following:

    • On the Help menu, click Samples.

      The Readme displays information about samples.

    • Visit the Visual Studio 2008 Samples Web site. The most recent versions of samples are available there.

    • Locate samples on the computer on which Visual Studio is installed. By default, samples and a Readme file are installed in drive:\Program Files\Microsoft Visual Studio 9.0\Samples\lcid. For Express editions of Visual Studio, all samples are located online.

For more information, see Visual Studio Samples.

Security noteSecurity Note:

This sample code is intended to illustrate a concept, and it shows only the code that is relevant to that concept. It may not meet the security requirements for a specific environment, and it should not be used exactly as shown. We recommend that you add security and error-handling code to make your projects more secure and robust. Microsoft provides this sample code "AS IS" with no warranties.

To run this sample

  • Press F5.

LINQ to Northwind is a LINQ to SQL database example program. The Samples.cs file contains fifteen sample LINQ to SQL queries stored in static methods that are named sequentially as Sample1(), Sample2(), and so on By default, the main file in the project, Program.cs, will call Sample1(). Edit Program.cs to call the other samples. For instance, to call the second sample, change the call to Samples.Sample1() to read Samples.Sample2().

See the Connectivity note found in the root directory for the samples project if you are have trouble running the database samples.


Many LINQ samples require XML files and/or the version of the Northwind sample database that is located in the Data sample. If you install the Data Sample in the same parent folder as the other LINQ samples, the path for the XML files and database file resolved automatically. Many sample files also require the Object Dumper Sample project.