| description | title | ms.date | ms.assetid |
|---|---|---|---|
Learn more about: Data Types and Functions |
Data Types and Functions |
03/30/2017 |
683413c5-0312-4e60-8619-9a97bdc6e62a |
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 [!INCLUDEvbtecdlinq] 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 xref:System.DateTime?displayProperty=nameWithType structure. |
| System.DateTimeOffset Methods | Describes LINQ to SQL support for members of the xref:System.DateTimeOffset?displayProperty=nameWithType 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 xref:System.TimeSpan?displayProperty=nameWithType structure. |
| Unsupported Functionality | Describes functionality that is not supported in [!INCLUDEvbtecdlinq]. |