Fixed
Details
Details
Assignee
Alex Zaytsev
Alex ZaytsevReporter
jf
jfLabels
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
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