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.

TopicDescription
SQL-CLR Type MappingProvides a detailed matrix of mappings between CLR types and SQL Server types.
Basic Data TypesSummarizes differences in behavior from the .NET Framework.
Boolean Data TypesSummarizes differences in behavior from the .NET Framework.
Null SemanticsProvides links to LINQ to SQL topics that discuss null and nullable issues.
Numeric and Comparison OperatorsSummarizes differences in behavior from the .NET Framework.
Sequence OperatorsSummarizes differences in behavior from the .NET Framework.
System.Convert MethodsSummarizes differences in behavior from the .NET Framework.
System.DateTime MethodsDescribes LINQ to SQL support for members of the System.DateTime structure.
System.DateTimeOffset MethodsDescribes LINQ to SQL support for members of the System.DateTimeOffset structure.
System.Math MethodsSummarizes differences in behavior from the .NET Framework.
System.Object MethodsSummarizes differences in behavior from the .NET Framework.
System.String MethodsSummarizes differences in behavior from the .NET Framework.
System.TimeSpan MethodsDescribes LINQ to SQL support for members of the System.TimeSpan structure.
Unsupported FunctionalityDescribes functionality that is not supported in LINQ to SQL.

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

Show: