I'm stuck with this linq query.
I've this tables.
ID A B C D 1 some data 2 some other data
Then, For every record on that table I may have none or many rows
ID TableA_ID R 1 1 1 2 1 2 3 1 5 4 2 2
For example. Row 1 (some data) has 3 rows on table B.
I tried using
tableA.Include(x => x.tablebchilds.Where( d => d.R == 1)).ToList()
but it is not working. With many others varation.
The objective of this query is to return
tableA.row #1 if I pass it
1 as value (value of
Number <> 2 won't give any result.
Tables are linked on EF. So
TableB.tableA_ID is Foreign key of
I tried the answers in the question marked as duplicated with no luck. Give that 2 tableA.rows if the user insert 1 as parameter, linq query should return Row #1, some data. If 2 is passed as parameter, nothing is return.
A working SQL statement is:
SELECT [TableA].* FROM [TableA] JOIN [TableB] ON [TableA].[Id] = [TableB].[TableA_Id] WHERE [TableB].[R] = 1