Background Information (LINQ to SQL)

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 the MSDN Library for specific issues.

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

• Study the whitepaper 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 (LINQ to SQL)
  Describes how to add validation code and other customizations.

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

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

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

• Data Retrieval and CUD Operations in N-Tier Applications (LINQ to SQL)
  Provides detailed information for multi-tier applications that use LINQ to SQL. 

• Object Identity (LINQ to SQL)
  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 (LINQ to SQL)
  Provides detailed information about how LINQ to SQL tracks changes.

• Optimistic Concurrency Overview (LINQ to SQL)
  Describes optimistic concurrency and defines terms.

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

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

• Serialization (LINQ to SQL)
  Describes the serialization process in LINQ to SQL applications.

• Stored Procedures (LINQ to SQL)
  Describes how to map stored procedures at design time and how to call them from your application.

• Transactions (LINQ to SQL)
  Outlines the three models of transaction that LINQ to SQL supports.

• SQL-CLR Type Mismatches (LINQ to SQL)
  Describes the challenges of mingling different type systems.

• SQL-CLR Custom Type Mappings (LINQ to SQL)
  Provides guidance on customizing type mappings.

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

Related Sections

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