Entities are not being tracked

[ynanech]

I am using EF Core to implement entity updates. After executing method one, there are no changes in the database. However, method two correctly updates the database. The only difference between the two methods is that in method one, userIds is of type IQueryable, while in method two, userIds is of type int[]. Why is it that the entities queried in method one are not being tracked?

        public async Task UpdatePostOne()
        {
            var userIds = _dbContext.Set<User>().Where(m => m.UserId == 123).Select(m => m.UserId);

            var posts= await _dbContext.Set<Post>()
                .Where(m => userIds.Contains(m.UserId) && !m.Deleted)
                .ToArrayAsync();

            foreach (var item in posts)
            {
                item.View+= 100;
            }
            await _dbContext.SaveChangesAsync();
        }


        public async Task UpdatePostTwo()
        {
            int[] userIds = [123];

            var posts= await _dbContext.Set<Post>()
                .Where(m => userIds.Contains(m.UserId) && !m.Deleted)
                .ToArrayAsync();

            foreach (var item in posts)
            {
                item.View+= 100;
            }
            await _dbContext.SaveChangesAsync();
        }

Include provider and version information

EF Core version: 8.0.6
Database provider: Microsoft.EntityFrameworkCore.SqlServer
Target framework: NET 8.0
Operating system: Win10
IDE: (e.g. Visual Studio 2022 17.10.3)

[roji]

@ynanech please submit a minimal, runnable code sample that shows the problem - a snippet isn't enough for us to investigate. Your first variant includes the query on the Users DbSet into the main query - that might not be returning the results you're expecting.