在Ado.net实体数据模型中添加条件 [英] Add condition in Ado.net Entity data model

问题描述

亲爱的所有人，

我在asp.net应用程序中使用 Ado.net Entiry数据模型.

从数据库中拖动任务表后，它将创建查询:
this._Tasks = base.CreateQuery<tasks>("[Tasks]");

我想在此处添加条件以通过taskID选择任务.

请对此提供帮助/建议.

-
YRishi

Dear All,

I am using Ado.net Entiry data model in my asp.net application.

After I drag my Task table from database, it will create query:
this._Tasks = base.CreateQuery<tasks>("[Tasks]");

I want to add condition here to select task by taskID.

Please help/suggest me on this.

-
YRishi

推荐答案

要通过id获取任务，您需要在单独的方法中实现它，例如GetTaskById(int taskId).并生成此行以通过EF
访问Tasks表
this._Tasks = base.CreateQuery<tasks>("[Tasks]");

因此，请勿尝试对其进行更改.

To get task by id you need to implement it in separate method, f.e. GetTaskById(int taskId). And this line is generated to access to Tasks table by EF

this._Tasks = base.CreateQuery<tasks>("[Tasks]");

So, don''t try to change it.

public Task GetTaskById(int taskId)
{
   yourDBEntities db=new yourDBEntities ();
   return db.Tasks.Where(task=>task.TaskId=taskId);
 }

否.您需要使用新类创建新文件. F.e. TaskRepository，您将在其中实现DAL. Entity Framework生成的Edmx文件需要在您的数据库和yourDBentities类之间提供映射.

No. You need to create new file with new class. F.e. TaskRepository where you''ll implement your DAL. Edmx file generated by Entity Framework needs to provide mapping between your DB and yourDBentities class.

这篇关于在Ado.net实体数据模型中添加条件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！