How to load only IDs when use many-to-many relationship in Entity Framework?

Asked May 27 '19 at 18:18

Active May 28 '19 at 07:34

Viewed 184 times

I have the following models:

class Item
{
    public ICollection<string> GroupIds { get; set; }

    // Introduced for EF only
    public ICollection<Group> Groups { get; set; }
}

class Group
{
    public ICollection<string> ItemIds { get; set; }

    // Introduced for EF only
    public ICollection<Item> Items { get; set; }
}

class Store
{
    public ICollection<Item> Items { get; set; }

    public ICollection<Group> Groups { get; set; }
}

Store contains all Items and all Groups, but every Item may be related with one or multiple Group and every Group may be related with one or multiple Item.

How I can configure many-to-many relationship between Item and Group to load only GroupIds and ItemIds, but not objects itself?

edited May 28 '19 at 06:59

asked May 27 '19 at 18:18

Aleksandr Vishnyakov

1,872
5
23
39

Duplicate, which means: you can't make EF to use the `string[]` properties and the other array properties should be `ICollection`. – Gert Arnold May 27 '19 at 20:00
Well, that doesn't matter. I can use ICollection and ICollection, ICollection, question still be the same – Aleksandr Vishnyakov May 28 '19 at 06:56
I'm asked not about how to configure many-to-many relationship, but how to have IDs only without loading objects themselves – Aleksandr Vishnyakov May 28 '19 at 06:58
OK, reopened, but then I'm not sure what you're asking. What I do know is that you can't map your current model with EF. – Gert Arnold May 28 '19 at 07:35

How to load only IDs when use many-to-many relationship in Entity Framework?

0 Answers0