Querying the Database
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer

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.

© 2016 Microsoft