zzz projects Entity Framework 6 EF 6
Home EF Core Articles Knowledge Base Online Examples
  • Home
  • EF Core
  • Articles
  • Knowledge Base
  • Online Examples

Entity Framework 6 - Knowledge Base (KB)

3 results in tag: subquery

Entity Framework sub query

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...
.net entity-framework subquery
asked by Gokulnath

Linq Sub Query (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... ...
entity entity-framework linq subquery
asked by Ahmet YETİK

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...
c# entity-framework join linq-to-entities subquery
asked by user1914530

Page 1 of 1
  • 1

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...

Related

  • EF Extensions Online Benchmark
  • WIN an EF Extensions license
  • EF6 BatchSaveChanges for only $79
Save your entities 20× faster with EF Extensions
SaveChanges vs BulkSaveChanges

EF Extensions
Try for free now
Get monthly updates by subscribing to our newsletter!
SUBSCRIBE!