Divide LINQ to Entity queries in to different methods

Question

want to be able to do something like this below. But I have a problem because the GetStudentByName method does not know what type data is.

Im able to write the "data = data.Where(s => s.name == "Some name");" without any problems. But how do i divide it into different methods?

    private IQueryable GetStudents()
    {
        var data = from a in db.Anvandning
                   select a;
        return data;
    }
    public IQueryable GetStudentByName(string name) 
    {
        var data = GetStudents();

        data = data.Where(s => s.name == name);     <-- Error occurs
        return data;
    }

Jon Skeet · Accepted Answer · 2011-05-16 09:15:57Z

1

You need to use IQueryable<T> instead of IQueryable, e.g

private IQueryable<Student> GetStudents()
{
    var data = from a in db.Anvandning
               select a;
    return data;
}

public IQueryable<Student> GetStudentByName(string name) 
{
    var data = GetStudents();

    data = data.Where(s => s.name == name);
    return data;
}

Note that these methods can be written more simply:

private IQueryable<Student> GetStudents()
{
    return db.Anvandning.Select(x => x);
}

public IQueryable<Student> GetStudentByName(string name) 
{
    return GetStudents().Where(s => s.name == name);
}

answered May 16, 2011 at 9:15

Jon Skeet

1.5m893 gold badges9.3k silver badges9.3k bronze badges

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

Collectives™ on Stack Overflow

Divide LINQ to Entity queries in to different methods

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related