how to give multiple where condition using linq query in mvc

Question

I want to give multiple where condition while binding data in mvc using linq. I tried where condition same as sql query and other type also but didnt work and showing error i.e.

The specified type member 'YearID' is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported.

Here is my code which I tried latest,

 public ActionResult FilterImage(int yearID, int eventID, int branchID)
{
    var content = db.eventRegistration.Select(s => new
    {
        s.EventRegistrationID,
        s.Image,
        s.IsActive
    });

    List<EventRegistrationViewModel> contentModel = content
       .Select(item => new EventRegistrationViewModel() 
       {
            EventRegistrationID = item.EventRegistrationID,
            Image = item.Image,
            IsActive = item.IsActive
       })
       .Where(c => c.IsActive == true && c.YearID == yearID && c.BranchID == branchID)
       .Take(15).ToList();

    return View(contentModel);
}

this code is not working for multiple where condition.

I know and this question is almost asked previous time but then also that answer is didn't work for this solution.

Thank You.

Problem is not in multiple conditions. Problem is in the single condition which uses `YearID` property. — Sergey Berezovskiy, Nov 22 '17 at 12:19
You should show how property `YearID` is defined in your entity — Sergey Berezovskiy, Nov 22 '17 at 12:21
Also I see that question which you telling as a duplicate but there solution is not get my question solution. — s.k.Soni, Nov 22 '17 at 12:25
It is really difficult to say whats wrong without seeing the entity definitions. — inthevortex, Nov 22 '17 at 13:50
You need to add following line -> .Where(c => c.IsActive == true || c.YearID == yearID || c.BranchID == branchID) — Raj G, Jan 19 '22 at 07:31

Curiousdev · Answer 1 · 2017-11-22T12:21:33.500

1

I don't know what you are trying but the solution is in content list you must have select YearID and BranchID because in where you are using it.

I don't know you need all properties or not it's different discussion but as of now you can do like below

 public ActionResult FilterImage(int yearID, int eventID, int branchID)
{
    var content = db.eventRegistration.Select(s => new
    {
        s.EventRegistrationID,
        s.Image,
        s.IsActive,
        s.YearID,
        s.BranchID
    }).ToList();

    List<EventRegistrationViewModel> contentModel = content.Select(item => new EventRegistrationViewModel()
    {
        EventRegistrationID = item.EventRegistrationID,
        Image = item.Image,
        IsActive = item.IsActive
    }).Where(c => c.IsActive == true && c.YearID == yearID && c.BranchID == branchID).Take(15).ToList();

    return View(contentModel);
}

edited Nov 22 '17 at 12:21

answered Nov 22 '17 at 12:16

Curiousdev

5,668
3
24
38

The same thing I have done and also describe in my question also and hence it showing error. – s.k.Soni Nov 22 '17 at 12:19
Ohh i think i got it i forgot to add `ToList()` in `content` please see updated answer – Curiousdev Nov 22 '17 at 12:21
@Curiousdev that brings whole database table to the client without any filtering applied on database side – Sergey Berezovskiy Nov 22 '17 at 12:22
Oh yes i know @SergeyBerezovskiy that's why i have already mentioned what he is doing with this i'm totally not awared – Curiousdev Nov 22 '17 at 12:23
@Curiousdev same code I have done see properly my question. – s.k.Soni Nov 22 '17 at 12:23
did you apply `.ToList()` at end of `content` ? in `Select(` extension method you must select all properties which you wants to use in `where` as i understand from dis side – Curiousdev Nov 22 '17 at 12:29

how to give multiple where condition using linq query in mvc

1 Answers1