Query:
Code: Select all
var query = from u in DbContext.Users
join ur in DbContext.UserRoles on u.Id equals ur.UserId
join r in DbContext.Roles on ur.RoleId equals r.Id
where u.IsSystem == true && u.DeletedAt == null && ur.DeletedAt == null
select new Domain.Users.UserWithRole
{
Id = u.Id,
FirstName = u.FirstName,
LastName = u.LastName,
Email = u.Email,
Activated = u.Activated,
Phone = u.PhoneNumber,
RoleName = r.Name
};
return query.ToArray();
Code: Select all
System.NullReferenceException: Object reference not set to an instance of an object
at Devart.Common.Entity.w.GenerateLiteral (System.Object value, Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping typeMapping) [0x00006] in <0fa51f7563e54c7cac3f29362f5a5df3>:0
at Microsoft.EntityFrameworkCore.Query.Sql.DefaultQuerySqlGenerator.VisitConstant (System.Linq.Expressions.ConstantExpression expression) [0x0002a] in <861afd9497d04ce091485c713400b127>:0
at System.Linq.Expressions.ConstantExpression.Accept (System.Linq.Expressions.ExpressionVisitor visitor) [0x00000] in <63992662b765477a898ef49cdcc99ee2>:0
at System.Linq.Expressions.ExpressionVisitor.Visit (System.Linq.Expressions.Expression node) [0x00006] in <63992662b765477a898ef49cdcc99ee2>:0