This documentation is archived and is not being maintained.

Querying the Database (LINQ to SQL)

This group of topics describes how to develop and execute queries in LINQ to SQL projects.

How to: Query for Information (LINQ to SQL)

Briefly shows how LINQ to SQL queries are basically the same as LINQ queries generally.

How to: Retrieve Information As Read-Only (LINQ to SQL)

Describes how to increase query performance when no change to the data is planned.

How to: Control How Much Related Data Is Retrieved (LINQ to SQL)

Describes how to control which related data is retrieved together with the main target.

How to: Filter Related Data (LINQ to SQL)

Describes how to retrieve related data by using a sub-query.

How to: Turn Off Deferred Loading (LINQ to SQL)

Describes how to turn off deferred loading.

How to: Directly Execute SQL Queries (LINQ to SQL)

Describes how to submit queries by using SQL language.

How to: Store and Reuse Queries (LINQ to SQL)

Describes how to compile a query one time but use it multiple times with different parameters.

How to: Handle Composite Keys in Queries (LINQ to SQL)

Describes how to include more than one column in a query where the operator takes only a single argument.

How to: Retrieve Many Objects At Once (LINQ to SQL)

Describes how to use LoadWith.

How to: Filter at the DataContext Level (LINQ to SQL)

Describes another use of LoadWith.

Query Examples (LINQ to SQL)

Provides many examples of queries.

Show: