Derived tables in Linq to SQL

Question

I would like to implement this in Linq to SQL:

select * from (
    select * from Orders) as A

Obviously this is a pointless example, but I just can't figure out how to do it!

Answer 1

using (var dc = new NorthwindDataContext())
{
             var A = from ordOuter in
                 from ordInner in dc.Orders
                 select ordInner
             select ordOuter;
}

Answer 2

Try something like this:

var subquery = from row in Orders select row;
var query = from row in subquery select row;