How to implement Linq query by converting entities to DTO?

Question

ASP.NET

How to pull the values ​​of entity B?

Answer 1

Automapper to help you

Answer 2

Nifiga did not understand what you want.
Pulled the request from the change history, corrected it a bit

await _context.A.Include(a => a.B)
                .ThenInclude(a => a.C)
                .Where(a => a.Id == 1)
                .Select(a => new ADto
                       {
                           Id = a.Id,                                                  
                           C = a.C.Select(c => new CDto { Id = c.Id, Name = c.Name}).ToList(),											 
                           B = new BDto { Id = a.B.Id, Name = a.B.Name }
                       })
                     .SingleAsync();

As I understand it, you want to recursively map values ​​from the BA sheet - this is a very bad idea and I would advise you to think about how you can do without it (for example, you can implement Lazy loading and give the client the value of this sheet only when the client opens some list)