Add ability to include collections into projections
Description
var error1 = db.Employees.Select(item => new { item.EmployeeId, OrderIDs = item.Orders.Select(od => od.OrderId) }).ToArray(); var error2 = db.Employees.Select(item => new { item.EmployeeId, Orders = item.Orders.Select(od => od) }).ToArray();
Two statements get the wrong SqlStrings (DB is SQL Server 2008).
error1: select employee0_.EmployeeId as col_0_0_, (select orders1_.OrderId from Orders orders1_ where employee0_.EmployeeId=orders1_.EmployeeId) as col_1_0_ from Employees employee0_
error2: select employee0_.EmployeeId as col_0_0_, . as col_1_0_, orders1_.OrderId as OrderId57_, orders1_.CustomerId as CustomerId57_, orders1_.EmployeeId as EmployeeId57_, orders1_.OrderDate as OrderDate57_, orders1_.RequiredDate as Required5_57_, orders1_.ShippedDate as ShippedD6_57_, orders1_.ShipVia as ShipVia57_, orders1_.Freight as Freight57_, orders1_.ShipName as ShipName57_, orders1_.ShipAddress as ShipAdd10_57_, orders1_.ShipCity as ShipCity57_, orders1_.ShipRegion as ShipRegion57_, orders1_.ShipPostalCode as ShipPos13_57_, orders1_.ShipCountry as ShipCou14_57_ from Employees employee0_ inner join Orders orders1_ on employee0_.EmployeeId=orders1_.EmployeeId
var error1 = db.Employees.Select(item => new { item.EmployeeId, OrderIDs = item.Orders.Select(od => od.OrderId) }).ToArray();
var error2 = db.Employees.Select(item => new { item.EmployeeId, Orders = item.Orders.Select(od => od) }).ToArray();
Two statements get the wrong SqlStrings (DB is SQL Server 2008).
error1:
select employee0_.EmployeeId as col_0_0_, (select orders1_.OrderId from Orders orders1_ where employee0_.EmployeeId=orders1_.EmployeeId) as col_1_0_ from Employees employee0_
error2:
select employee0_.EmployeeId as col_0_0_, . as col_1_0_, orders1_.OrderId as OrderId57_, orders1_.CustomerId as CustomerId57_, orders1_.EmployeeId as EmployeeId57_, orders1_.OrderDate as OrderDate57_, orders1_.RequiredDate as Required5_57_, orders1_.ShippedDate as ShippedD6_57_, orders1_.ShipVia as ShipVia57_, orders1_.Freight as Freight57_, orders1_.ShipName as ShipName57_, orders1_.ShipAddress as ShipAdd10_57_, orders1_.ShipCity as ShipCity57_, orders1_.ShipRegion as ShipRegion57_, orders1_.ShipPostalCode as ShipPos13_57_, orders1_.ShipCountry as ShipCou14_57_ from Employees employee0_ inner join Orders orders1_ on employee0_.EmployeeId=orders1_.EmployeeId