Entity Framework 6 - Knowledge Base (KB)

Sub query in Entity Framework

How to write sub queries like these in EF?...select * from table1 where col1 in (select col1 from table2 where col2 = 'xyz') ...or...select * from table1 where col1 not in (select col1 from table2 where col2 = 'xyz') ...I tried something like these...from...

Sub Query in Linq (SELECT in SELECT)

I have got a native join sub query problem in MySQL Entity. SQL code is;...DB structure is;...tbl_urunler_kod...id..., ...kod... - 1, pkod1... - 2, pkod2... - 3, pkod3...tbl_urunler...id..., ...kod_id... - 1, 1... - 2, 2... - 3, 3... - 4, null... ...

Linq to Entities many to many selection: How to force the generation of a JOIN instead of a subselect clause?

Using EF DB first I have two entities (Supplier, Product) that have a many-to-many relationship. Entity Framework does not create an entity for the associated table (SupplierProduct) as the associated table contains only the primary keys of the strong ent...