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

浙公网安备 33010602011771号