How to give multiple where condition using linq query in MVC

Question

0.00/5 (No votes)

See more:

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.

What I have tried:

I tried many things but didnt work anything.

Posted 22-Nov-17 1:27am

Member 11339247

Updated 22-Nov-17 2:04am

Add a Solution

2 solutions

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)

Dave Kreskowiak · Answer 1 · 2017-11-22T02:00:00

I don't know where you got that var content line from, but its what is causing your problem. It doesn't have a YearID column in it, only the columns you gave it in that first Select. You don't need that line of code at all.

You just need the second one, modified slightly:

C#

public ActionResult FilterImage(int yearID, int eventID, int branchID)
{
    List<EventRegistrationViewModel> contentModel = db.eventRegistration
       .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);
}

F-ES Sitecore · Answer 2 · 2017-11-22T02:04:00

Does EventRegistrationViewModel have YearID and BranchID properties? You probably need to do your Where before your Select on the eventRegistration direct.

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

We don't have access to your database so it's hard to say for sure.

How to give multiple where condition using linq query in MVC

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0