Q: EF-Core How to stop nested objects using Include When using Include UserRole its load all child objects, Why SQL use inner join not left join? 
data of departments are no problem but only UserRole I want stop load [users] under [UserRole] 
Image: data here
public partial class User_Master
{   
    public virtual UserRole UserRole { get; set; }
}

public partial class UserRole
{
    public virtual ICollection<User_Master> Users { get; set; };
}

/
modelBuilder.Entity<User_Master>(e => {
                    e.HasOne(p => p.UserRole).WithMany(b => b.Users).HasForeignKey(k => k.user_role_id).OnDelete(DeleteBehavior.Restrict);
                    e.HasOne(p => p.Department).WithMany(b => b.Users).HasForeignKey(k => k.department_code).IsRequired(false).OnDelete(DeleteBehavior.Restrict);
                });

/
_db.User_Master.Include(x => x.UserRole).Include(x => x.Department).OrderBy(m => m.name).AsNoTracking();

