Data Types and Functions

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 Provides a detailed matrix of mappings between CLR types and SQL Server types.
Basic Data Types Summarizes differences in behavior from the .NET Framework.
Boolean Data Types Summarizes differences in behavior from the .NET Framework.
Null Semantics Provides links to LINQ to SQL topics that discuss null and nullable issues.
Numeric and Comparison Operators Summarizes differences in behavior from the .NET Framework.
Sequence Operators Summarizes differences in behavior from the .NET Framework.
System.Convert Methods Summarizes differences in behavior from the .NET Framework.
System.DateTime Methods Describes LINQ to SQL support for members of the DateTime structure.
System.DateTimeOffset Methods Describes LINQ to SQL support for members of the DateTimeOffset structure.
System.Math Methods Summarizes differences in behavior from the .NET Framework.
System.Object Methods Summarizes differences in behavior from the .NET Framework.
System.String Methods Summarizes differences in behavior from the .NET Framework.
System.TimeSpan Methods Describes LINQ to SQL support for members of the TimeSpan structure.
Unsupported Functionality Describes functionality that is not supported in LINQ to SQL.

See Also

SQL-CLR Type Mismatches
Reference
.NET Framework Class Library in Visual Studio