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.