Improve exception for client-server join

[ronaldkipngetich8923]

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.

[ronaldkipngetich8923]

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;

[smitpatel]

Joining with client side collection cannot be translated to server.

[roji]

Better exception message?

[ajcvickers]

Backlog for better exception message.