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

Allen 5

My code:
1.Error

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));

Out error (Almost no answer found online):
引发的异常:“System.InvalidCastException”(位于 System.Private.CoreLib.dll 中)

“System.InvalidCastException”类型的未经处理的异常在 System.Private.CoreLib.dll 中发生

Unable to cast object of type 'System.Linq.Expressions.TypedParameterExpression' to type 'System.Linq.Expressions.LambdaExpression'.

2.Normal (Do not use : Func<AModel, float> p = property => property.Balance;)

ADal aDal = new ADal();

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

Hui Liu-MSFT 48,616 Microsoft Vendor

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));

Allen 5 Reputation points

2023-07-26T17:54:49.4066667+00:00

..........
Allen 5 Reputation points

2023-07-26T18:00:23.0266667+00:00

I have already sent it, can you see it?

Allen 5

Visual Studio 2022
.NET 7.0
ASP.NET Core Web API Project
OS Windows10
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));
        }

Hui Liu-MSFT 48,616 Reputation points Microsoft Vendor

2023-07-27T05:42:46.2666667+00:00

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

2023-07-27T15:36:48.3333333+00:00

Hello, yes i tried.

For the code one: The compiler indicates that there is no definition of a Parameter

For the code two: SetProperty() Code only support Func<AModel, float>, And does not support Expression<Func<AModel, float>>

Hui Liu-MSFT 48,616 Microsoft Vendor

Hi,@Allen. Is it possible to test if the following code works?

Expression<Func<SetPropertyCalls<AModel>, SetPropertyCalls<AModel>>> p = e => e.SetProperty(a => a.Balance, 636);

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

İsa Sayın 5 Reputation points

2024-06-30T12:18:02.7566667+00:00
I also have the same problem and exception when trying to ExecuteUpdate some records.

System.InvalidCastException: 'Unable to cast object of type 'System.Linq.Expressions.TypedParameterExpression' to type 'System.Linq.Expressions.LambdaExpression'.'

Using EF Core 8 - SQL Server

I'm trying to use ExecuteUpdate method looks like this:

public void BulkUpdate<TProperty>(Func<T, TProperty> propertyExpression, TProperty value) { _context.Set<T>().ExecuteUpdate(s => s.SetProperty(propertyExpression, value)); }

And i call method like this:

repository.BulkUpdate(p => p.Sheet, "x1x3x");

1 answer

Bruce (SqlWork.com) 71,511 Reputation points

2023-07-31T17:32:24.8533333+00:00

with linq to entities (used with db context), the callback are expression trees, not code. the expression tree is a small ast tree of the lambda code. when the query is executed, the driver converts the expression tree to sql syntax. the driver are very restrictive (unlike the compiler) in what code is allowed in the expression.

https://learn.microsoft.com/en-us/dotnet/csharp/advanced-topics/expression-trees/

in you case the driver is telling you it can can not convert the function "p" to sql. how would the SQL Server execute the c# function? how would the driver get the code of the function to generate sql?

note: some drivers allow you to create sql function and install in the database, and map to a function name.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

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

1 answer

Your answer