无法翻译.或者以可以翻译的形式重写查询

Two pieces of code from the old project are moved to the new project, and this way of defining logic in entities is wrong. For some reason, the EF of the new project is 3.14, and the EF of the old project is 2.14


 if (_couponManager.GetAllCustomerCouponsRL()
               .Any(m =>  couponIdList.Contains(m.CouponId) && !m.GetIsUse))
            {
                map.IsHaveCoupon = true;
            }
            else
            {}

    public class CouponCustomerRL : Effective_BaseSanyuanGroupPurchaseEntity<Guid>, IHasModificationTime
    {
...
        public bool GetIsUse
        {
            get
            {
                if (this.IsLock) return true;
                return this.IsUse;
            }
        }
}

Error message

Mvc.ExceptionHandling.AbpExceptionFilter - The LINQ expression 'DbSet<CouponCustomerRL>
    .Where(c => __ef_filter__p_0 || !(((ISoftDelete)c).IsDeleted))
    .Any(c => (Nullable<Guid>)c.CustomerId == __input_CustomerId_0 && __couponIdList_1.Contains(c.CouponId) && !(c.GetIsUse()) && DateTime.Now > c.StartTime && DateTime.Now < c.EndTime)' could not be translated. Either rewrite the query in a form that can be translated, or switch to client evaluation explicitly by inserting a call to either AsEnumerable(), AsAsyncEnumerable(), ToList(), or ToListAsync(). See https://go.microsoft.com/fwlink/?linkid=2101038 for more information.

Good Question 0Comment Collection Report

0 Answer

dk5chiyou 注册会员
2023-02-28 16:22

This answer quotes ChatGPT

This error message is because EF Core 3.14 has query tracing enabled by default and does not support converting method calls into SQL queries. In older projects, EF Core 2.14 May not have query tracing enabled or may have converted method calls.

You can try inserting the ToList() method into the query to convert the query into a memory query to resolve the error. For example:

if (_couponManager.GetAllCustomerCouponsRL()
               .ToList()
               .Any(m => couponIdList.Contains(m.CouponId) && !m.GetIsUse))
{
    map.IsHaveCoupon = true;
}
else
{
    // ...
}

Inserting the ToList() method into the query can turn the query into an in-memory query, but it is important to note that doing so can cause performance problems, especially if the amount of data is large. If you need to query large amounts of data, it is recommended to use transformation-enabled queries or optimized queries.

Agree 0 0Comment

About the Author

: javaprograms 注册会员
这家伙很懒，什么都没留下...

0: Answer

0: Article

0: Question

Question Info

Publish Time: 2023-02-28 16:22

Update Time: 2023-02-28 16:22