Unsupported Functionality

In LINQ to SQL, the following SQL functionality cannot be exposed through translation of existing common language runtime (CLR) and .NET Framework constructs:

• STDDEV

• LIKE

  Although LIKE is not supported through direct translation, similar functionality exists in the SqlMethods class. For more information, see SqlMethods.Like.

• DATEDIFF

  LINQ to SQL has limited support for DATEDIFF. Similar functionality exists in the SqlMethods class.

• ROUND

  LINQ to SQL has limited support for ROUND. For more information, see System.Math Methods.

See also

• Data Types and Functions