4
select fieldA from TableA
where fieldA = 459249 and
fieldB in (
select FieldC
from TableB
where FieldD in
(
select cte.FieldE
from TableC cte
where key= 'ABDC123'
)
)
I managed to get to the point below, the project does not compile:
TableA.Where(x => x.FieldA == 459249)
.Select(x => x.FieldA .Contains(TableB.Select(i => i.FieldB).Contains
(
TableC.Where(c => c.FieldC== "ABDC123").Select(c => c.FieldD).ToString()
)
));
Do not compile? What is the build error?
– Renan
The error happens here Tableb.Select(i => i.Fieldb).Contains. The type cannot be inferred from the Usage. Try specifying the type Arguments explicity. I tried typing but get error message "Cannot resolve method Contains (string).
– Tiago Crizanto