Entity Framework Query #1

Question

I'm trying to figure out how to limit my child dataset to only include active records...

    // Here's what I have currently...
    m_BackLoggerEntities.Stories
     .Include("Sprints")
     .Include("Tasks")
     .Include("Efforts")
     .Include("Products")
     .First(s => s.StoryId == id);


    // Here's what I thought I could do...
    m_BackLoggerEntities.Stories
     .Include("Sprints")
     .Include("Tasks")
     .Include("Efforts")
     .Include("Products")
     .Where(s => s.Tasks.Active)
     .First(s => s.StoryId == id);


    // I also tried this...
    m_BackLoggerEntities.Stories
     .Include("Sprints")
     .Include("Tasks")
     .Include("Efforts")
     .Include("Products")
     .First(s => s.StoryId == id && s => s.Tasks.Active));

Obviously none of these are working. I'm not sure how else to do this...

What exactly is the problem? Are you getting an exception? Zero results? Too many results? ??? — jrista
– jrista, Commented Oct 29, 2009 at 16:22

user2392071 · Accepted Answer · 2013-05-21 21:04:28Z

2

You need something like this:

Model = m_BackLoggerEntities.Stories
    .Include("Sprints")
    .Include("Tasks")
    .Include("Efforts")
    .Include("Products")
    .SingleOrDefault(s => s.StoryId == id);

Then, in your view:

@foreach (var task in Model.Tasks.Where(t => t.Active))

answered May 21, 2013 at 21:04

user2392071

414 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Altonymous Over a year ago

This is a very old question.... "Oct 29 '09" Thanks but I was trying to AVOID using the foreach. How it was implemented was inconsequential to me.

Misha N. · Accepted Answer · 2009-10-29 17:07:36Z

1

Take a look at Alex James Tip 37. According to example in linked article, it can be done like this:

var query = from story in m_BackLoggerEntities.Stories
            where story.StoryId == id
            select new {
                          story,
                          Tasks = from task in story.Tasks
                                  where task.Active
                                  select task
                       };

var stories = query
   .AsEnumerable()
   .Select(x => x.Story);

Each Story inside of "stories" should have only active Tasks.

answered Oct 29, 2009 at 17:07

Misha N.

3,4551 gold badge30 silver badges36 bronze badges

Comments

Altonymous · Accepted Answer · 2009-10-29 16:17:32Z

1

The only way I've found to "simulate" what I want is to use...

        var storyToDetail =
            m_BackLoggerEntities.Stories
                .Include("Sprints")
                .Include("Tasks")
            .Include("Efforts")
            .Include("Products")
                .First(s => s.StoryId == id);

Then in the foreach in the view...

            <% foreach (var task in Model.Tasks.Where(t => t.Active))

But this of course brings back a lot more records then I want.

answered Oct 29, 2009 at 16:17

Altonymous

7837 silver badges26 bronze badges

Collectives™ on Stack Overflow

Entity Framework Query #1

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related