如何在.edmx.cs文件中写入条件 [英] How to wirte where condition in .edmx.cs file

问题描述

亲爱的所有人，

我创建了model.edmx文件，其中使用了两个表1)Project和2)Task
我的任务是特定于项目的.此后，我只想显示那些由用户选择项目的任务.

我的表是
项目
ProjectID
项目名称
说明

任务
TaskID
ProjectID
TaskName
说明


当我从数据库中为Model.edmx选择表时，它将获取所有数据库数据，因此我将无法查看选定的项目数据.

如有其他查询，请回复我.
请分享您的想法.

-
YRishi

Dear All,

I have create model.edmx file in which I have used two tables 1)Project and 2)Task
My task are project specific. Henceforth I want to show only those task which project is selected by User.

MY tables are
Project
ProjectID
ProjectName
Description

Task
TaskID
ProjectID
TaskName
Description


When i select tables from database for Model.edmx, it will fetch all the database data so I will be not able to view selected project data.

Please revert me back in case of any other query.
Please share your ideas.

-
YRishi

推荐答案

Quick&脏溶液

IEnumerable<Task> tasksByProject = context.Projects.Where(project => project.ProjectId == 1).First().Tasks.Where(tasks => tasks.ProjectID == 1);

我在LINQ&中非常陌生实体框架，所以此解决方案可能不是最好的解决方案，但这可能会让您有个主意.

Quick & dirty solution

IEnumerable<Task> tasksByProject = context.Projects.Where(project => project.ProjectId == 1).First().Tasks.Where(tasks => tasks.ProjectID == 1);

I am very new in LINQ & Entity Framework thing so this solution may not be the best possible one but this might give you an idea.

非常感谢Saini Arun，这将对我有所帮助.

Thanks a lot Saini Arun, This will help me.

这篇关于如何在.edmx.cs文件中写入条件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！