Loading

Hi, how to do this sql in EF. Select *, (select status from tableB wh

Padma

Hi, how to do this sql in EF. Select *, (select status from tableB where tableA.AId = tableB.BId) from tableA. Don’t want to do raw sql. Any idea how?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Rajanikant Hawaldar5y ago
Accepted answer
Something like this
From a in context.TableA
Join b in context.TableB on a.Aid equals b. Bid
Select New{
a.aid,
Other relevant fileds from a
B.bid
}
0