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.

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.

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.

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.

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.

Concepts

Other Resources