LINQ to Entity : Supported and Unsupported Methods

Article
01/02/2009

There is a correction for this Post, so do I have changed the title. Thanks to Chris Love who pointed me the faults with earlier post,

I got few question on some of the popular paging methods of LINQ which does not work on LINQ to Entity. This is by design and quite logical. In LINQ to SQL scenario they do translate to native TSQL and uses some of its properties and functions. Thus this cannot be made generic for other databases like Oracle/DB2.

There is a list published in MSDN with the operators at,

Projection and Restriction Methods (LINQ to Entities)

Lists the supported and unsupported projection and restriction methods.

Join Methods (LINQ to Entities)

Lists the supported and unsupported joining methods.

Set Methods (LINQ to Entities)

Lists the supported and unsupported set methods.

Ordering Methods (LINQ to Entities)

Lists the supported and unsupported ordering methods.

Grouping Methods (LINQ to Entities)

Lists the supported and unsupported grouping methods.

Aggregate Methods (LINQ to Entities)