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

Environment

None
100% Done
Loading...

Activity

Show:

Alex Zaytsev September 8, 2014 at 11:32 AM

Close issues resolved in 3.3.3

Alex Zaytsev January 26, 2013 at 1:09 PM

Ported-back to 3.3.x fd0842119f9ec8af0c4b648506dd5586386657b0

Alex Zaytsev January 25, 2013 at 8:40 AM

Fixed in master (c91880894eb3965f04513d3b78991dab014dafc9)

Fixed

Details

Assignee

Reporter

Labels

Components

Fix versions

Affects versions

Priority

Who's Looking?

Open Who's Looking?
Created December 23, 2011 at 3:25 AM
Updated September 8, 2014 at 11:32 AM
Resolved January 25, 2013 at 8:40 AM
Who's Looking?