Abp9.0.4运行DbMigrator,报错“The LINQ expression '@__organizationUnitIds_0' could not be translated. ...”

今天刚升级到最新版,然后创建个项目玩玩,在执行DbMigrator,进行数据库迁移时,报错:
System.InvalidOperationException:“The LINQ expression '@__organizationUnitIds_0' could not be translated. Additional information: Primitive collections support has not been enabled. Either rewrite the query in a form that can be translated, or switch to client evaluation explicitly by inserting a call to 'AsEnumerable', 'AsAsyncEnumerable', 'ToList', or 'ToListAsync'. See https://go.microsoft.com/fwlink/?linkid=2101038 for more information.”

原因

是Abp用到了Pomelo.EntityFrameworkCore.MySql 9.0.0-preview.2.efcore.9.0.0导致

解决方案

XXXEntityFrameworkCoreModule中加入代码即可:

Configure<AbpDbContextOptions>(options =>
{
    options.UseMySQL(builder =>
    {
        //加入代码
        builder.TranslateParameterizedCollectionsToConstants();
    });
});
posted @ 2025-02-10 17:03  HUGO.CM  阅读(119)  评论(0)    收藏  举报