Background Information

The topics in this section pertain to concepts and procedures that extend beyond the basics about using LINQ to SQL.

Follow these steps to find additional examples of LINQ to SQL code and applications:

• Search Microsoft Docs for specific issues.

• Participate in the LINQ Forum, where you can discuss more complex topics in detail with experts.

• Study the white paper that details LINQ to SQL technology, complete with Visual Basic and C# code examples. For more information, see LINQ to SQL: .NET Language-Integrated Query for Relational Data.

In This Section

ADO.NET and LINQ to SQL
Describes the relationship of ADO.NET and LINQ to SQL.

Analyzing LINQ to SQL Source Code
Describes how to analyze LINQ to SQL mapping by generating and viewing source code from the Northwind sample database.

Customizing Insert, Update, and Delete Operations
Describes how to add validation code and other customizations.

Data Binding
Describes how LINQ to SQL uses IListSource to support data binding.

Inheritance Support
Describes the role of inheritance in the LINQ to SQL object model, and how to use related operators in your queries.

Local Method Calls
Describes LINQ to SQL support for local method calls.

N-Tier and Remote Applications with LINQ to SQL
Provides detailed information for multi-tier applications that use LINQ to SQL.

Object Identity
Describes object identity in the LINQ to SQL object model, and explains how this feature differs from object identity in a database.

The LINQ to SQL Object Model
Describes the object model and its relationship to the relational data model.

Object States and Change-Tracking
Provides detailed information about how LINQ to SQL tracks changes.

Optimistic Concurrency: Overview
Describes optimistic concurrency and defines terms.

Query Concepts
Describes aspects of queries in LINQ to SQL that differ from queries in LINQ.

Retrieving Objects from the Identity Cache
Describes the types of queries that retrieve objects from the identity cache.

Security in LINQ to SQL
Describes the correct approach to security in database connections.

Serialization
Describes the serialization process in LINQ to SQL applications.

Stored Procedures
Describes how to map stored procedures at design time and how to call them from your application.

Transaction Support
Outlines the three models of transaction that LINQ to SQL supports.

SQL-CLR Type Mismatches
Describes the challenges of mingling different type systems.

SQL-CLR Custom Type Mappings
Provides guidance on customizing type mappings.

User-Defined Functions
Describes how to map user-defined functions at design time and how to call them from your application.

Related Sections

Programming Guide
Includes links to sections that explain various aspects of the LINQ to SQL.