Can anyone be darling and convert this SQL query to Linq and EF

Question

User283528319 posted

Hi all,

I need to convert this SQL query into LINQ EF version.

select evraklar.* from `numune_sahipleri`
join `evraklar` on `numune_sahipleri`.`evraklar_id`=evraklar.`evraklar_id`
join `sevkedilen_lablar` on `evraklar`.`evraklar_id`=`sevkedilen_lablar`.`evraklar_id`
where birimler_id=1 and `numune_sahipleri`.adisoyadi like ('%Name%');

but no luck trying to convert it using include and theninclude and where (which is obviously not working after theninclude)

Answer 1

User475983607 posted

The pseudo SQL is not complete.  We can accurately answer this question if you share the Entities.

The EF documentation covers joins and joins and the pattern is pretty simple.  

https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/ef/language-reference/query-expression-syntax-examples-join-operators

Answer 2

User283528319 posted

can't we solve the problem using include and then include instead of joins?

Answer 3

User475983607 posted

fatihbarut

can't we solve the problem using include and then include instead of joins?

Sure, the Include() extension loads related data but you have not shared the Entities (or sample code) which contain the navigation properties.

Include reference documentation

https://docs.microsoft.com/en-us/ef/core/querying/related-data