1. Add the below nuget package to your project:

   EFCore.ChangeTriggers.ChangeEventQueries
   

2. Enable ChangeEventQueries on your ChangeTriggersDbContextOptionsBuilder:

   services.AddDbContext<MyDbContext>(options =>
   {
    options
        .UseSqlServer()
        .UseSqlServerChangeTriggers(options =>
        {
            options
                .UseChangeEventQueries();
        });
   });