CODEWITHSUNDEEP
c#entity-frameworklinqmany-to-many
user11563179
user11563179

Reputation:

LINQ. Loading related elements

I have an entity Contracts, ListKindWorks and KindWorks. 

public partial class Contracts
{
    public Contracts()
    {
        ListKindWorks = new HashSet<ListKindWorks>();
    }

    public int Id { get; set; }
    ...
    public virtual ICollection<ListKindWorks> ListKindWorks { get; set; }
}

public partial class ListKindWorks
{
    public int IdContract { get; set; }
    public int IdKindWork { get; set; }

    public virtual Contracts IdContractNavigation { get; set; }
    public virtual KindWorks IdKindWorkNavigation { get; set; }
}

public partial class KindWorks
{
    public KindWorks()
    {
        ListKindWorks = new HashSet<ListKindWorks>();
    }

    public int Id { get; set; }
    public string Title { get; set; }
    public virtual ICollection<ListKindWorks> ListKindWorks { get; set; }
}

I want to load related elements. Something like this pseudocode:

source = model.Contracts
    .Select(c => new MyType
    {
        IdContract = c.Id,
        KindWork = new List<Item>
        { Id = KindWorks.Id, Value = KindWorks.Title }

        // or
        //    KindWork = c.ListKindWorks
        //           .Where(x => x.IdContract == c.Id)
        //           .Select(y => new Item 
        //           { Id = y.IdKindWork, Value = y.IdKindWorkNavigation.Title })
        ... 
    })
    .ToList();

public class Item
{
    public int Id { get; set; }
    public string Value { get; set; }
}

Can I load List<Item> for each Contracts?

Upvotes: 0

Views: 45

Answers (2)

user11563179
user11563179

Reputation: 

    IEnumerable<Item> KindWork = c.ListKindWorks
    .Select(y => new Item 
    { 
        Id = y.IdKindWork, 
        Value = y.IdKindWorkNavigation.Title
    })

    IEnumerable<Item> Subject = c.ListSubjects
    .Select(y => new Item
    { 
        Id = y.IdSubject, 
        Value = y.IdSubjectNavigation.Title
    })

Upvotes: 0

Guilhem Prev
Guilhem Prev

Reputation: 979

If I understand what you are looking for, I create a List for each contract in a dictionary. And here is my result:

var contracts = new List<Contracts>
{
    new Contracts { Id = 1 },
    new Contracts { Id = 2 },
    new Contracts { Id = 3 },
};

var listKindWorks = new List<ListKindWorks>
{
    new ListKindWorks { IdContract = 1, IdKindWork = 1 },
    new ListKindWorks { IdContract = 1, IdKindWork = 2 },
    new ListKindWorks { IdContract = 2, IdKindWork = 2 },
    new ListKindWorks { IdContract = 2, IdKindWork = 3 }
};

var kindWorks = new List<KindWorks>
{
    new KindWorks { Id = 1, Title = "Title 1" },
    new KindWorks { Id = 2, Title = "Title 2" },
    new KindWorks { Id = 3, Title = "Title 3" },
};

Dictionary<Contracts, List<Item>> myDic = contracts.Select(
    contract => contract).ToDictionary(
    contract => contract,
    contract => listKindWorks.Where(
            listKindWork => listKindWork.IdContract.Equals(contract.Id))
        .Select(listKindWork => new Item
        {
            Id = kindWorks.FirstOrDefault(kindWork => kindWork.Id.Equals(listKindWork.IdKindWork))?.Id?? listKindWork.IdKindWork,
            Value = kindWorks.FirstOrDefault(kindWork => kindWork.Id.Equals(listKindWork.IdKindWork))?.Title?? "KindWork not found"
        }).ToList());

I obtain this for my test :

Contract1 : Title1, Title2
Contract2 : Title2, Title3
Contract3 : Nothing

Upvotes: 1

Related Questions