blocks|key|326444|text|您可以使用条件映射：http://www.codeproject.com/Articles/94784/Using-Conditional-Mapping-in-Entity-Framework|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|326445|entityMap|0|LINK|mutability|MUTABLE|url|http://www.codeproject.com/Articles/94784/Using-Conditional-Mapping-in-Entity-Framework^0|A|2F|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

You could use conditional mappings: <a href="http://www.codeproject.com/Articles/94784/Using-Conditional-Mapping-in-Entity-Framework" rel="nofollow">http://www.codeproject.com/Articles/94784/Using-Conditional-Mapping-in-Entity-Framework</a>

blocks|key|295336|text|更新|type|unstyled|depth|inlineStyleRanges|entityRanges|data|295337|下面给定的解决方案不起作用。它仍然给出了下面给出的错误映射。|295338|所以终于找到了一个简单的愚蠢的解决方案。添加存储过程。|295339|我保留了先前的答案，以供参考。|295340|295341|扩展到被接受的回答伊夫维布洛。|295342|上面为我工作过。|295343|除此之外，我不得不做一些改变。|295344|当条件映射完成时，就会产生错误。|295345|从x行开始映射片段的|295346|问题:条件成员'Student.Deleted‘与'IsNull=False’以外的条件映射。要么删除Student.Deleted上的条件，要么从映射中删除它。|blockquote|295347|295348|295349|作为给定here的推理，我从实体中删除了已删除的列。|offset|length|295350|现在的问题是如何删除(标记删除)的学生，因为我的实体没有被删除的属性。|295351|我做了以下|295352|将designer|295353|Renamed中的|unordered-list-item|295354|复制粘贴到StudentWithDeleted|ordered-list-item|style|CODE|295355|Added+deleted列中的Student实体到StudentWithDeleted|295356|Mapped，StudentWithDeleted实体粘贴到表student中的映射详细信息。|295357|295358|295359|现在，当我想删除(标记已删除)一个学生，我只是打开StudentWithDeleted实体使用find(StudentId)，分配deleted=1和保存。|295360|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/a/6001395/62889^0|0|0|0|0|0|0|0|0|0|0|0|0|0|4|4|0|0|0|0|0|0|5|I|0|6|7|G|7|Q|I|0|7|I|V|7|0|0|0|P|I|1B|F|1T|9|0^^$0|@$1|2|3|4|5|6|7|1V|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1W|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|1X|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|1Y|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|1Z|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|20|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|21|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|22|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|23|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|24|8|@]|9|@]|A|$]]|$1|S|3|T|5|U|7|25|8|@]|9|@]|A|$]]|$1|V|3|-4|5|6|7|26|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|27|8|@]|9|@]|A|$]]|$1|X|3|Y|5|6|7|28|8|@]|9|@$Z|29|10|2A|1|2B]]|A|$]]|$1|11|3|12|5|6|7|2C|8|@]|9|@]|A|$]]|$1|13|3|14|5|6|7|2D|8|@]|9|@]|A|$]]|$1|15|3|16|5|6|7|2E|8|@]|9|@]|A|$]]|$1|17|3|18|5|19|7|2F|8|@]|9|@]|A|$]]|$1|1A|3|1B|5|1C|7|2G|8|@$Z|2H|10|2I|1D|1E]]|9|@]|A|$]]|$1|1F|3|1G|5|1C|7|2J|8|@$Z|2K|10|2L|1D|1E]|$Z|2M|10|2N|1D|1E]|$Z|2O|10|2P|1D|1E]]|9|@]|A|$]]|$1|1H|3|1I|5|1C|7|2Q|8|@$Z|2R|10|2S|1D|1E]|$Z|2T|10|2U|1D|1E]]|9|@]|A|$]]|$1|1J|3|-4|5|6|7|2V|8|@]|9|@]|A|$]]|$1|1K|3|-4|5|6|7|2W|8|@]|9|@]|A|$]]|$1|1L|3|1M|5|6|7|2X|8|@$Z|2Y|10|2Z|1D|1E]|$Z|30|10|31|1D|1E]|$Z|32|10|33|1D|1E]]|9|@]|A|$]]|$1|1N|3|-4|5|6|7|34|8|@]|9|@]|A|$]]]|1O|$1P|$5|1Q|1R|1S|A|$1T|1U]]]]

<h2>UPDATE</h2>

Below given solution is not working.
It still gives error Mapping given below.

So finally gone for a simple stupid solution. Adding a stored procedure.

I have kept the previous answer for reference.

<hr>

Extension to accepted answer of ivowiblo.

Above worked for me.

Apart from that I had to do few changes.

When conditional mapping is done it gave error 

<blockquote>
 Problem in mapping fragments starting at line x:Condition member
 'Student.Deleted' with a condition other than 'IsNull=False' is
 mapped. Either remove the condition on Student.Deleted or remove it
 from the mapping.
</blockquote>

I removed the Deleted column from entity as reasoning given <a href="https://stackoverflow.com/a/6001395/62889">here</a>.

Now the issue was how to delete(mark deleted) the student as my entity is not having deleted property.

I did following 

<ol>
<li>Copy pasted <code>Student</code> entity in designer</li>
<li>Renamed it to <code>StudentWithDeleted</code></li>
<li>Added <code>deleted</code> column to <code>StudentWithDeleted</code></li>
<li>Mapped the <code>StudentWithDeleted</code> entity to table <code>student</code> in mapping details.</li>
</ol>

Now when I want to delete(mark deleted) a student, I just open the <code>StudentWithDeleted</code> entity using <code>find(StudentId)</code>, assign <code>deleted=1</code> and save.

I need to create an entity with filtered results.

eg. 
I have one table Student.
Through designer I am able to create student entity.
When I delete a student the requirement is to just change a field deleted=true instead of actual delete.

So the problem is whenever I try to access student it gives entire list including the deleted student.
So I have to add code as <code>.where(c=&gt; c.deleted=false)</code> wherever the list is used.

So the requirement is to create an entity with a filter.

I tried to use view but it has its own problems. Like it need a primary key and is readonly, etc.

Entity framework 4 create a entity with filtered results

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我需要创建一个具有过滤结果的实体。例如：我有一张桌子学生。通过设计师，我可以创建学生实体。当我删除一个学生时，要求只是更改字段deleted=true，而不是实际删除。所以问题是，每当我试图访问学生时，它都会给出包括被删除的学生在内的整个列表。因此，我必须将代码作为.where(c=> c.deleted=false)...

问实体框架4创建具有过滤结果的实体。
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问实体框架4创建具有过滤结果的实体。EN