Export (0) Print
Expand All
0 out of 1 rated this helpful - Rate this topic

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 System.DateTime structure.

System.DateTimeOffset Methods

Describes LINQ to SQL support for members of the System.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 System.TimeSpan structure.

Unsupported Functionality

Describes functionality that is not supported in LINQ to SQL.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.