views:

153

answers:

2

I'm looking for such list for LINQ to SQL. Ideally, I'd like to have a list of other supported methods (or members - e.g. constructors), e.g. for DateTime type.

A: 

http://msdn.microsoft.com/en-us/library/bb337580.aspx . All those extension methods are documented as members of IQueryable.

Rembmer that IQueryable implements IEnumerable, so anything that IEnumerable implements is also available on IQueryable, with the caveat that some of those methods don't work! In particular, anything that uses a custom comparator will compile correctly, but will get a run-time error from LINQ to SQL. Also true for .Take() and .Skip() with non-numeric values.

Cylon Cat
I fully aware about IQueryable and IEnumerable (I'm one of developers of ORM tool supporting LINQ). Your reply isn't helpful, because only a subset of IQueryable methods is supported by *any* LINQ provider. The question itself indicates I know a complete list of these methods...
Alex Yakunin
Then your question certainly isn't clear. Why would DateTime be handled differently from any other value type? What constructors (of any type) would be supported by IQueryable, which is an interface? What other methods would Iqueryable support, other than those defined on it or on the interfaces it inherits from?
Cylon Cat
Alex Yakunin
Please see the accepted answer - it must clean up everything.
Alex Yakunin
+2  A: 

Yes, although less complete than for L2E. See also Data Types and Functions. This includes DateTime and DateTimeOffset.

Craig Stuntz
I accepted the reply, since it seems this is the most comprehensive information that can be found. There is no list of supported \ unsupported IQueryable methods - there are just (some?) examples of unsupported ones: http://msdn.microsoft.com/en-us/library/bb882656.aspx
Alex Yakunin