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 'AsEnumerable', 'AsAsyncEnumerable'

 

通常會發生在

第一個集合 left join 第二個集合這邊

第一個集合這裡可能要先撈取出來(.ToList() ....etc)

然後也要記得把握住前後集合順序

from 數量少的join 數量多的on

即可修正

Ref:

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 'AsEnumerable', 'AsAsyncEnumerable'

https://www.cnblogs.com/xiaogaopan/p/15384353.html

could not be translated. Either rewrite the query in a form that can be translated

https://blog.csdn.net/qq_42799562/article/details/120162877?ops_request_misc=&request_id=&biz_id=102&utm_term=could%20not%20be%20translated.%20Eithe&utm_medium=distribute.pc_search_result.none-task-blog-2~all~sobaiduweb~default-0-120162877.142^v56^control_1,201^v3^add_ask&spm=1018.2226.3001.4187