Data Types and Functions (LINQ to SQL)

The topics listed in the following table describe LINQ to SQL support for members, constructs, and casts of the common language runtime (CLR). Supported members and constructs are available to use in your LINQ to SQL queries.

An unsupported item in the table means that LINQ to SQL cannot translate the CLR member, construct, or cast for execution on the SQL Server. You may still be able to use them in your code, but they must be evaluated before the query is translated to Transact-SQL or after the results have been retrieved from the database.

Topic

Description

SQL-CLR Type Mapping (LINQ to SQL)

Provides a detailed matrix of mappings between CLR types and SQL Server types.

Basic Data Types (LINQ to SQL)

Summarizes differences in behavior from the .NET Framework.

Boolean Data Types (LINQ to SQL)

Summarizes differences in behavior from the .NET Framework.

Null Semantics (LINQ to SQL)

Provides links to LINQ to SQL topics that discuss null and nullable issues. 

Numeric and Comparison Operators (LINQ to SQL)

Summarizes differences in behavior from the .NET Framework.

Sequence Operators (LINQ to SQL)

Summarizes differences in behavior from the .NET Framework.

System.Convert Methods (LINQ to SQL)

Summarizes differences in behavior from the .NET Framework.

System.DateTime Methods (LINQ to SQL)

Describes LINQ to SQL support for members of the System.DateTime structure.

System.DateTimeOffset Methods (LINQ to SQL)

Describes LINQ to SQL support for members of the System.DateTimeOffset structure.

System.Math Methods (LINQ to SQL)

Summarizes differences in behavior from the .NET Framework.

System.Object Methods (LINQ to SQL)

Summarizes differences in behavior from the .NET Framework.

System.String Methods (LINQ to SQL)

Summarizes differences in behavior from the .NET Framework.

System.TimeSpan Methods (LINQ to SQL)

Describes LINQ to SQL support for members of the System.TimeSpan structure.

Unsupported Functionality (LINQ to SQL)

Describes functionality that is not supported in LINQ to SQL.

See Also

Reference

SQL-CLR Type Mismatches (LINQ to SQL)

Other Resources

Reference (LINQ to SQL)

.NET Framework Class Library in Visual Studio