Why would I want to use an ExpressionVisitor?

最新推荐文章于 2025-09-06 22:56:13 发布

转载最新推荐文章于 2025-09-06 22:56:13 发布 · 223 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/chucklu/p/11580266.html

文章标签：

#数据库

本文介绍了一种使用ExpressionVisitor解决EntityFramework无法调用转换方法的问题。在一个应用中，数据库字段包含0或1，而应用需要使用布尔值。通过创建一个Flag对象并使用ExpressionVisitor在发送到EF前修改属性访问，成功解决了转换问题。

Why would I want to use an ExpressionVisitor?

There was a issue where on the database we had fields which contained 0 or 1 (numeric), and we wanted to use bools on the application.

The solution was to create a "Flag" object, which contained the 0 or 1 and had a conversion to bool.

We used it like a bool through all the application, but when we used it in a .Where() clause the EntityFramework complained that it is unable to call the conversion method.

So we used a expression visitor to change all property accesses like .Where(x => x.Property) to .Where(x => x.Property.Value == 1) just before sending the tree to EF.

转载于:https://www.cnblogs.com/chucklu/p/11580266.html