开发者

UDF call in entity framework is cached

开发者 https://www.devze.com 2022-12-25 13:32 出处:网络
I am doing a test after reading an article http://blogs.msdn.com/alexj/archive/2009/08/07/tip-30-how-to-use-a-custom-store-function.aspx about udf function called. When I use a function withobjectCont

I am doing a test after reading an article http://blogs.msdn.com/alexj/archive/2009/08/07/tip-30-how-to-use-a-custom-store-function.aspx about udf function called. When I use a function with objectContext.Entities.Where( t=> udf(para1, para2) == 1), here the Entities is not ObjectQuery, but an ObjectSet, the first time I call the 开发者_如何学编程method, it runs correctly, if I reuse the objectContext,and run it again but with different para1, para2, then the previous parameter values still cached, and the result is same as previous one, which is wrong. The sql profiler shows that both query hit the database, but the t-sql is the same. Am I missing something? And the ObjectSet does not support .where(esql_string). How to get udf working with ObjectSet?

Thanks Fred


Fred,

What you describe sounds a lot like a bug in EF 4.

I'll forward to some people on the EF team to investigate.

Alex

0

精彩评论

暂无评论...
验证码 换一张
取 消