List specific data with lambda via MVC controller

Question

I'm trying to list every comments created by the the specific user (Users Id stored in Session["LoggedUserID"]) but I'm having hard time solving the lambda expression as I basically never done it before.

The following code is faulty, but this about what I had in mind.

 public ActionResult MyComments(Guid? id)
        {
            id = new Guid(Session["LoggedUserID"].ToString());

            var comments = db.Comments.Include(m=> m.CreatorUserId.Equals(id));

            return View(comments.ToList());

        }

Addintional info:

Database-first
Using Guids for Id's.

Any help is much appreciated.

You are using Include instead of Where, include should be used when you want to expand an entity inside your comments, ex: the user CreatorUser — Haitham Shaddad
– Haitham Shaddad, Commented Sep 27, 2016 at 5:59

Orel Eraki · Accepted Answer · 2016-09-26 23:30:24Z

2

It will be more helpful if you would publish your relevant entities SQL scheme, but this should suffice.

I've used LINQ to Entities .Where method in order to filter only the one matching the given id.
Include is not needed, because it is used for loading relative entities, which is not needed for Comments table.

Code:

public ActionResult MyComments(Guid? id)
{
    id = Guid.Parse(Session["LoggedUserID"].ToString());

    var review = db.Comments.Where(m => m.CreatorUserId.Equals(id));
    var result = review.ToList(); 

    return View(result);
}

answered Sep 26, 2016 at 23:30

Orel Eraki

12.2k4 gold badges31 silver badges38 bronze badges

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

Comments

Berkay Yaylacı · Accepted Answer · 2016-09-26 23:31:25Z

2

Try this instead of include,

db.Comments.Where(m=> m.CreatorUserId == id);

Hope helps,

answered Sep 26, 2016 at 23:31

Berkay Yaylacı

4,5132 gold badges22 silver badges39 bronze badges

Collectives™ on Stack Overflow

List specific data with lambda via MVC controller

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related