EntityFrameworkCore 7 SetProperty(avar,avalue) Unable to cast object of type 'System.Linq.Expressions.TypedParameterExpression' to type 'System.Linq.Expressions.LambdaExpression'.

Hi,@Allen. What is your project type? Is there a minimal example code and steps that can reproduce the problem? You could also try the code below to see if it works.
Code one:

ADal aDal = new ADal();

Func<AModel, float> p = property => property.Balance;

aDal._databaseContext
    .ModelDbSet
    .Where(w => w.ID == 5)
    .Take(1)
    .ExecuteUpdate(e => e.SetProperty(Expression.Lambda<Func<AModel, float>>(Expression.Property(e.Parameter, "Balance"), e.Parameter), 636));

Code two:

ADal aDal = new ADal();

Expression<Func<AModel, float>> p = property => property.Balance;

aDal._databaseContext
   .ModelDbSet
   .Where(w => w.ID == 5)
   .Take(1)
   .ExecuteUpdate(e => e.SetProperty(p, 636));

..........

I have already sent it, can you see it?

1. Visual Studio 2022
2. .NET 7.0
3. ASP.NET Core Web API Project
4. OS Windows10
5. Microsoft.EntityFrameworkCore 7.0.9

My Code:

 public class BaseDbContext : DbContext
    {
        protected BaseDbContext()
        {
        }

        public BaseDbContext(DbContextOptions options) : base(options)
        {
        }

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            if (!optionsBuilder.IsConfigured)
            {
                optionsBuilder.UseMySql
                (
                    GetConnectionString
                    (
                        "test_database",
                        DalAppSettingsHelper.AppSettings.Database.Server,
                        DalAppSettingsHelper.AppSettings.Database.Port,
                        DalAppSettingsHelper.AppSettings.Database.UserID,
                        DalAppSettingsHelper.AppSettings.Database.Password
                    ),
                    new MySqlServerVersion(DalAppSettingsHelper.AppSettings.Database.Version)
                );
            }
        }

        public static string GetConnectionString(string Database, string Server, uint Port, string UserID, string Password)
        {
            return new MySqlConnectionStringBuilder
            {
                Server = Server,
                Port = Port,
                SslMode = MySqlSslMode.None,
                Database = Database,
                UserID = UserID,
                Password = Password
            }.ConnectionString;
        }
    }

    public class DatabaseTestContext : BaseDbContext
    {
        public DatabaseTestContext(DbContextOptions options) : base(options)
        {
        }

        protected DatabaseTestContext()
        {
        }

        public DbSet<AModel> ModelDbSet { get; set; }
    }

    [Table("test_table")]
    public class AModel
    {
        [Key]
        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public int ID { get; set; }

        public float Balance { get; set; }
    }

    public class MyBaseDal
    {
        public readonly DatabaseTestContext _databaseContext;

        public MyBaseDal()
        {
            _databaseContext = Create
            (
                "test_database",
                "localhost",
                3306,
                "root",
                "root",
                "5.7.26"
            );
        }

        public DatabaseTestContext Create(string database, string server, uint port, string userID, string password, string version)
        {
            return new DatabaseTestContext(new DbContextOptionsBuilder<DatabaseTestContext>().UseMySql
            (
                BaseDatabaseContext.GetConnectionString
                (
                    database,
                    server,
                    port,
                    userID,
                    password
                ), new MySqlServerVersion(version)
            ).Options);
        }
    }

    public class ADal : MyBaseDal
    {
    }

Call:

Error:

        static void Te()
        {
            ADal aDal = new ADal();

            Func<AModel, float> p = property => property.Balance;

            aDal._databaseContext
            .ModelDbSet
            .Where(w => w.ID == 5)
            .Take(1)
            .ExecuteUpdate(e => e.SetProperty(p, 636));
        }

Normal:

        static void Tes()
        {
            ADal aDal = new ADal();

            aDal._databaseContext
            .ModelDbSet
            .Where(w => w.ID == 5)
            .Take(1)
            .ExecuteUpdate(e => e.SetProperty(p => p.Balance, 636));
        }

Hi,@Allen. Thanks for the feedback. To confirm that the approach in the comments works, did you test it?