实体框架-多对多联接 [英] Entity Framework - Join on many to many

问题描述

我有一个简单的多对多关系，我想知道如何从中获取数据.这是设置

I have a simple many to many relationship and I am wondering how you get data out of it. Here is the setup

媒体 Media_Keyword(许多地图) 关键字

Media Media_Keyword (many to many map) Keyword

这是我的代码:

    public List<Keyword> GetFromMedia(int mediaID)
    {
        var media = (from m in Connection.Data.Media
                   where m.id == mediaID
                   select m).First();

        var keys = (from k in media.Media_Keyword
                    select new Keyword {ID = k.Keywords.id, Name = k.Keywords.keyword});

        return keys.ToList();
    }

有没有办法更好地做到这一点?

Is there a way to do this better?

推荐答案

通常，我从多对多地图中选择右键.

Usually, I select right from the many-to-many map.

var keys = from k in Connection.Data.Media_Keyword
       where k.MediaID == mediaID
       select k.Keywords;

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