using System;

using System.Linq;

using Microsoft.EntityFrameworkCore;

public class Entity

{

    public int Id { get; set; }

    public string text { get; set; }

}

​

public class Program

{   

    public static void Main()

    {

        using (var context = new EntityContext())

        {

            context.Database.EnsureCreated();

            var connection = context.Database.GetDbConnection();

            connection.Open();

            var entities = context.Entities.Where(entity => entity.text != "changed");          

            foreach (var entity in entities){

                entity.text = "changed";

            }

​

            System.Console.WriteLine(entities.Count());

            context.Entities.UpdateRange(entities);

            context.SaveChanges();

            System.Console.WriteLine(entities.Count());

        }

    }

}

​

public class EntityContext : DbContext

{

        public DbSet<Entity> Entities {get; set;}

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)

        {

            optionsBuilder

                .UseSqlServer(FiddleHelper.GetConnectionStringSqlServer())

                .EnableSensitiveDataLogging()

                .EnableDetailedErrors();

        }

​

        protected override void OnModelCreating(ModelBuilder modelBuilder)

        {

            modelBuilder.Entity<Entity>()

                .HasData(

                    new Entity { Id = 1, text="one" },

                    new Entity { Id = 2, text="two" },

                    new Entity { Id = 3, text="three" }

                );

        }

}

​