Simple ASP.NET MVC SQL related question

Question

Good Morning,

I have the following code:

  public ActionResult ViewCategory(int category)
    {
        var items = from indexVariable in DatabaseEntities.classifieds
                    where indexVariable.category = category
                    select indexVariable;
        return View(items.ToList());
    }

This code doesn't work, the error is on the where line. I am sure you can all see what I am trying to achieve, I want to only pull up results for the specified category.

Many Thanks.

Darin Dimitrov · Accepted Answer · 2010-11-07 12:52:58Z

1

Use double == for boolean expressions, the simple = is an assignment operator:

where indexVariable.category == category

answered Nov 7, 2010 at 12:52

Darin Dimitrov

1.0m275 gold badges3.3k silver badges3k bronze badges

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

1 Comment

JHarley1 Over a year ago

Cheers, that was a completely stupid question on reflection. But I was sat there trying to figure it out for an age.

Collectives™ on Stack Overflow

Simple ASP.NET MVC SQL related question

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related