实体框架联接 [英] Entity FrameWork Joins

问题描述

我有3张桌子:

**地区**:
ID，
名称

**区**
ID，
RegionID，
名称

**城市**
ID，
DistrictID，
名称


当我这样写的时候:

I have 3 Tables:

**Region**:
ID,
Name

**District**
ID,
RegionID,
Name

**City**
ID,
DistrictID,
Name


When I write like this:

var result = (from item in db.Region.Include("District.City") select item).ToList();

结果我有了彼此依赖的对象

例如:在地区"中，我有2个对象，在地区4"中，在城市"中有8个对象

我想用Linq Join而不是include
写这个

In result I have objects Dependent on each other

for example: In Region I have 2 Objects, In District 4 objects and In City 8 Objects

I want to write this with Linq Join not with include
can you help me??

推荐答案

可以使用内部联接吗?

Can you use an inner join, something like:

var result = from region in db.Region
             join district in db.District on district.RegionID equals region.ID
             join city in db.City on city.DistrictID equals district.DistrictID
             select ...

这篇关于实体框架联接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！