I need help with Converting this Select statement in LINQ C#
Code
SELECT TagName
from Tags
Where TagId IN(
SELECT TagId
from PresentationTags
Where PresentationId = 2
)
Where()
with nested Any()
should do the job
context.Tags.Where(
x => context.PresentationTags.Any(
y => y.PresentationId == 2 && x.TagId == y.TagId
)
).Select(x => x.TagName);