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.
