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.
- 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.
