Improve exception for client-server join

Processing of the LINQ expression 'DbSet
.Join(
outer: __p_0,
inner: domainUser => domainUser.DomainAccessID,
outerKeySelector: domain => domain.ID,
innerKeySelector: (domainUser, domain) => new {
domainUser = domainUser,
domain = domain
})' by 'NavigationExpandingExpressionVisitor' failed. This may indicate either a bug or a limitation in EF Core. See https://go.microsoft.com/fwlink/?linkid=2101433 for more detailed information.

This is the code:

                var userDomains = await GetUserDomainsAsync(adminId);
            
                var users = await (from domainUser in _context.DomainUsers
                                   join domain in userDomains on domainUser.DomainAccessID equals domain.ID

                                   join user in _context.TvaUsers on domainUser.TvaUserID equals user.ID
                                   select new DomainUserViewModel
                                   {
                                       DomainModel = domain,
                                       TvaUserModel = _mapper.Map<TvaUserModel>(user)
                                   }).ToListAsync();

                return users;

Joining with client side collection cannot be translated to server.

Better exception message?

Backlog for better exception message.

Navigation Menu

Repository navigation

Improve exception for client-server join #21914

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Improve exception for client-server join #21914

Description

Activity

ronaldkipngetich8923 commented on Aug 3, 2020

smitpatel commented on Aug 3, 2020

roji commented on Aug 4, 2020

ajcvickers commented on Aug 7, 2020

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions