How to wirte where condition in .edmx.cs file

Question

1.00/5 (1 vote)

See more:

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

Posted 24-Jan-11 23:37pm

yrishi

Add a Solution

Comments

dasblinkenlight 25-Jan-11 5:43am

I think this question has a better chance of being answered if you ask it in the DB forum, because it's mostly about fetching data using Entity Framework, and not about displaying it using ASP.NET.

2 solutions

Solution 2

Thanks a lot Saini Arun, This will help me.

Posted 25-Jan-11 0:40am

yrishi

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

saini arun · Accepted Answer · 2011-01-25T00:28:00

Solution 1

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.

Posted 25-Jan-11 0:28am

saini arun

Comments

saini arun 25-Jan-11 6:36am

Or use "views" in case you want it to be done at database level.