Code: Select all
from car in _carsContext.Cars
select new CarDto()
{
ID = car.ID,
Brand = car.NAME,
HasMoreThenOneModel = ((from model in _carsContext.Models
where model.CAR_ID == car.ID
select model).Count() > 1)
}
In that case we get the SQL error "ORA-00933: SQL command not properly ended"
Generated SQL (value of p__TypedProperty_0 is 1):
Code: Select all
SELECT "c".ID, "c".NAME "Brand", (CASE
WHEN (
SELECT COUNT(*)
FROM MODELS "m"
WHERE "m".CAR_ID = "c".ID) > 1 THEN 1
ELSE 0
END) "HasMoreThenOneModel", (CASE
WHEN EXISTS (
SELECT 1
FROM MODELS "m0"
WHERE "m0".CAR_ID = "c".ID) THEN 1
ELSE 0
END) "HasModels", 1 "isCar"
FROM CARS "c"
WHERE ((
SELECT COUNT(*)
FROM MODELS "m1"
WHERE "m1".CAR_ID = "c".ID) > 1) = :p__TypedProperty_0