Select with entity framework in N: M with multiple objects

Question

Select with entity framework in N: M with multiple objects

Navigation

#1 by (2 votes)

1

I have the following classes: Client, Contact, Phone, Campaign, and Customer Campaign.

Where CampaignCustomer, has a campaign, has a Client (who has a phone list and a contact list and who may have a phone list).

I can give a Select in the Customer Campaign that you are looking for: Campaign, Client, Customer Phone List, Contact List, but not the Contacts Phone list.

return banco.CampanhasClientes.Include(x=>x.Cliente).Where(x=>x.Campanha.Id == _campanha.Id).ToList();

c# entity-framework

asked by anonymous 10.02.2018 / 01:52

1 answer

Graphs - return a pointer to the adjacency array Concatenating values directly in the query is problematic?

score 2 · Answer 1

I managed with the code below, I thought I had tried this option, I do not know if it is the best. If you have a better way ...

return banco.CampanhasClientes.Include(x=>x.Cliente.Contatos.Select(c=>c.Telefones)).Where(x=>x.Campanha.Id == _campanha.Id).ToList();