LINQ WHERE query problem in C#

Question

Ok im trying to get a MVC example page working and basically query where a certain id is specified but i'm fairly new to it all and after an hour of trying to figure this out im hoping of you can help me!!

code below is a method from my taskController.cs that is called via /tasks/complete/2

//mark task as complete
    public ActionResult Complete(int id)
    {
        IEnumerable<task> tasks = from t in db.tasks where t.taskID = id select t;


        foreach (task myTask in tasks)
        {
            myTask.isComplete = true;
        }
        db.SubmitChanges();

        return RedirectToAction("Index");
    }

Joel · Accepted Answer · 2009-03-10 17:12:07Z

10

While the terms might sound similar, it's important to remember that LINQ is not SQL. Try using double equals for comparison:

 IEnumerable<task> tasks = from t in db.tasks where t.taskID == id select t;

answered Mar 10, 2009 at 17:12

Joel

19.4k3 gold badges67 silver badges84 bronze badges

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

2 Comments

Andrew Over a year ago

thank you, i thought it may be something simple that i'd overlooked - appreciate the help

hunter Over a year ago

didn't "=" throw an exception? Does for me.

Ian Suttle · Accepted Answer · 2009-03-10 17:13:17Z

3

try "==" for "where t.taskID == id"

answered Mar 10, 2009 at 17:13

Ian Suttle

3,3822 gold badges25 silver badges28 bronze badges

1 Comment

Andrew Over a year ago

He probably starting writing at the same time but does it really need commenting on?

Collectives™ on Stack Overflow

LINQ WHERE query problem in C#

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related