LINQ (How Do I in Visual Basic)

This page links to topics about Language-Integrated Query (LINQ). To view other categories of popular tasks covered in Help, see How Do I in Visual Basic.

General

• Introduction to LINQ in Visual Basic
  Provides an in-depth description of LINQ for Visual Basic users.

• Getting Started with LINQ in Visual Basic
  Provides background information about LINQ queries and the new language features that support LINQ.

• Walkthrough: Writing Queries in Visual Basic
  Shows how to create queries on a list of objects, how to run the queries, and how to modify them.

• Queries (Visual Basic)
  Provides links to reference topics about query expressions in Visual Basic.

Using LINQ to Objects

• LINQ to Objects
  Introduces a section of How-to topics for using LINQ with in-memory collections.

• How to: Combine Data with LINQ by Using Joins (Visual Basic)
  Shows how to combine multiple collections into a single collection in which items from each collection are joined together based on matching key values.

Using LINQ to SQL

• Getting Started (LINQ to SQL)
  Provides an introduction and guide for using LINQ to SQL.

• What You Can Do With LINQ to SQL
  Demonstrates key database operations in LINQ to SQL: selecting, inserting, updating, and deleting.

• How to: Query a Database by Using LINQ (Visual Basic)
  Provides an example of how to connect to a SQL Server database and execute a query by using LINQ.

• How to: Call a Stored Procedure by Using LINQ (Visual Basic)
  Provides an example of how to connect to a SQL Server database and call a stored procedure by using LINQ.

• How to: Modify Data in a Database by Using LINQ (Visual Basic)
  Provides an example of how to connect to a SQL Server database and retrieve and modify data by using LINQ.

• How to: Sort a Collection by Using LINQ (Visual Basic)
  Provides an example of how to order the results of a query by using LINQ.

• How to: Filter Query Results by Using LINQ (Visual Basic)
  Provides an example of how to include search criteria in a query by using LINQ.

• How to: Count, Sum, or Average Data by Using LINQ (Visual Basic)
  Provides examples of how to include aggregate functions to Count, Sum, or Average data returned from a query by using LINQ.

• How to: Find the Minimum or Maximum Value in a Query Result by Using LINQ (Visual Basic)
  Provides examples of how to include aggregate functions to determine the minimum and maximum values of data returned from a query by using LINQ.

• How to: Return a LINQ Query Result as a Specific Type (Visual Basic)
  Provides an example of how to return the results of a LINQ query as a specific type instead of as an anonymous type.

• The LINQ to SQL Object Model
  Shows how an object model is mapped to the data model of a relational database.

• Typical Steps for Using LINQ to SQL
  Lists the steps to follow in order to implement a LINQ to SQL application, with links to supporting information at each step.

• Walkthrough: Simple Object Model and Query (Visual Basic) (LINQ to SQL)
  Shows how to create an entity class that models a table in a database, and how to execute a simple query.

• Walkthrough: Querying Across Relationships (Visual Basic) (LINQ to SQL)
  Shows how to query across tables that have been mapped into a hierarchical object relationship.

• Walkthrough: Manipulating Data (Visual Basic) (LINQ to SQL)
  Shows how to add, update, delete and modify data in a database.

• Walkthrough: Using Only Stored Procedures (Visual Basic) (LINQ to SQL)
  Shows how to use stored procedures in LINQ to SQL.

• How to: Display Generated SQL (LINQ to SQL)
  Shows how to display and view the SQL that is generated and issued to the database by the LINQ to SQL runtime.

• How to: Directly Execute SQL Queries (LINQ to SQL)
  Shows how to issue raw SQL commands in place of a LINQ query.

• O/R Designer Overview
  Provides an introduction to using the visual design tool for creating LINQ to SQL entity classes and associations that are based on objects in a database.

• How to: Add LINQ to SQL Classes to a Project (O/R Designer)
  Shows how to use the Add New Item dialog box to add LINQ to SQL files to projects.

• How to: Create DataContext Methods Mapped to Stored Procedures and Functions (O/R Designer)
  Shows how to add stored procedures to the O/R Designer as DataContext methods.

• Walkthrough: Creating LINQ to SQL Classes (O/R Designer)
  Shows how to create entity classes that are based on objects in a database, and how to display the data on a Windows Form.

Using LINQ to XML

• How to: Enable XML IntelliSense in Visual Basic
  Shows how to add an XML schema to a Visual Basic project to provide XML IntelliSense that shows possible attributes, child elements, or descendant elements for XML literals.

• How to: Create XML Literals (Visual Basic)
  Shows how to create an XML element in code by using an XML literal.

• How to: Embed Expressions in XML Literals
  Shows how to use embedded expressions in XML literals to create content at run time.

• How to: Access XML Descendant Elements (Visual Basic)
  Shows how to use a descendant axis property to access all XML elements that have a specified name and that are contained under a specified XML element.

• How to: Access XML Child Elements (Visual Basic)
  Shows how to use a child axis property to access all XML child elements that have a specified name in an XML element.

• How to: Access XML Attributes (Visual Basic)
  Shows how to use an attribute axis property to access all XML attributes that have a specified name in an XML element.

• How to: Declare and Use XML Namespace Prefixes
  Shows how to declare an XML namespace prefix and use it to create and access XML elements.

• How to: Load XML from a File, String, or Stream (Visual Basic)
  Shows how to populate an XML literal from a string, file, or stream.

• How to: Modify XML Literals (Visual Basic)
  Shows how to modify the contents of an existing XML literal. This includes adding and removing elements and attributes and modifying element and attribute values.

• How to: Transform XML by Using LINQ (Visual Basic)
  Shows how to transform the contents of an XML literal into a new format.

Using LINQ to DataSet

• Loading Data Into a DataSet
  Describes how to populate a dataset object so that you can query over it.

• Single-Table Queries (LINQ to DataSet)
  Describes how to perform queries against a single table in a dataset.

• Cross-Table Queries (LINQ to DataSet)
  Describes how to perform queries across multiple tables in a dataset.

• Querying Typed DataSets
  Describes how to perform queries against typed datasets.

• LINQ to DataSet Examples
  Provides many examples of how to perform various query operations, such as restriction, projection, ordering, and partitioning.

See Also

Concepts

How Do I in Visual Basic

Introduction to LINQ in Visual Basic

Other Resources

LINQ Sample Applications in Visual Basic