Linq to SQL: Inner select query and performance : Consider the following query, will it causes multiple trips to db to execute the inner select statement?

    Table1.Select(x=> new{
       x.T1_Name,
       x.T1_Id,
       x.Table2.Select(y=> new {
          y.T2_Name,
          y.T2_Value
       }
    }).ToList();

My guess is it would not since it's still an `IQueryable` and the whole query would be run on DB and the final result would be passed to client. 

In `LinqPad` the inner query triggers multiple times.