Filtering data from Entity Framework

Question

I have simple method where I retrieve data from database and send it to the View. But in the meantime data need to filtered. I have below code:

public ActionResult Index(string Name, string Manufacturer)
    {
        var dev = db.Devices;
        if(!String.IsNullOrEmpty(Name))
        {
            dev = dev.Where(w => w.Name.Contains(Name));
        }
        if(!String.IsNullOrEmpty(Manufacturer))
        {
            dev = dev.Where(w => w.Manufacturer.Contains(Manufacturer));
        }
        return View(dev.ToList());
    }

but I'm getting this error:

Cannot implicitly convert type 'System.Linq.IQueryable' to 'System.Data.Entity.DbSet'. An explicit conversion exists (are you missing a cast?)

I tried adding cast eg:

(DbSet<Device>)

But didn't helped. Can anyone suggest me how to modify my code?

please look at this stackoverflow.com/questions/12788425/… — mit
– mit, Commented Feb 6, 2014 at 10:58

James · Accepted Answer · 2014-02-06 11:18:59Z

5

The problem is db.Devices will be a DbSet<Device> collection, not an IQueryable<T>, so on these lines

dev = dev.Where(...)

the Where will return IQueryable<T> and given DbSet<T> can't be implicitly set as IQueryable<T> you get an exception.

What you need to do here is convert your DbSet<T> to an IQueryable<T> and that can be done pretty easily by calling AsQueryable i.e.

var dev = db.Devices.AsQueryable();

edited Feb 6, 2014 at 11:18

answered Feb 6, 2014 at 10:58

James

82.4k19 gold badges172 silver badges245 bronze badges

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

Comments

Markus · Accepted Answer · 2014-02-06 11:01:47Z

4

By

var dev = db.Devices;

you declare dev to be of type DbSet<Device>. The Where-methods return an IQueryable and therefore, you cannot use the variable dev. Change the declaration as follows:

var dev = db.Devices.AsQueryable();

edited Feb 6, 2014 at 11:01

answered Feb 6, 2014 at 10:56

Markus

22.7k4 gold badges34 silver badges61 bronze badges

1 Comment

James Over a year ago

You mean IQueryable<Device>.

Collectives™ on Stack Overflow

Filtering data from Entity Framework

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related