cannot be called with instance of type 'System.Data.Entity.Core.Objects.ObjectQuery

Question

I want to Find Username by userId

this code snippet working

Discussion_CreateBy = db.AspNetUsers.Find(discussion.CreatedBy).UserName,

and this once not working in following controller class

Comment_CreateBy = db.AspNetUsers.Find(c.CreatedBy).UserName,

this is my model classes

public class DiscussionVM
{
    public int Disussion_ID { get; set; }
    public string Discussion_Title { get; set; }
    public string Discussion_Description { get; set; }
    public Nullable<System.DateTime> Discussion_CreateDate { get; set; }
    public string Discussion_CreateBy { get; set; }

    public string Comment_User { get; set; }

    public IEnumerable<CommentVM> Comments { get; set; }

}

public class CommentVM
{

    public int Comment_ID { get; set; }
    public Nullable<System.DateTime> Comment_CreateDate { get; set; }
    public string Comment_CreateBy { get; set; }
    public string Comment_Description { get; set; }

}

this is whole controller class

    public ActionResult Discussion_Preview()
    {
        int Discussion_ID = 1;

        var discussion = db.AB_Discussion.Where(d => d.Discussion_ID == Discussion_ID).FirstOrDefault();
        var comments = db.AB_DiscussionComments.Where(c => c.Discussion_ID == Discussion_ID);



        DiscussionVM model = new DiscussionVM()
        {

            Disussion_ID = discussion.Discussion_ID,
            Discussion_Title = discussion.Discussion_Name,
            Discussion_Description = discussion.Discussion_Name,
            Discussion_CreateBy = db.AspNetUsers.Find(discussion.CreatedBy).UserName,
            Discussion_CreateDate = discussion.CreatedDate,

            Comments = comments.Select(c => new CommentVM()

            {
                Comment_ID = c.Comment_ID,
                Comment_Description = c.Comment_Discription,
                Comment_CreateBy = db.AspNetUsers.Find(c.CreatedBy).UserName,                    
                Comment_CreateDate = c.CreatedDate

            })

        };



        return View(model);
    }

Getting following error

Method 'Project.Models.AspNetUser Find(System.Object[])' declared on type 'System.Data.Entity.DbSet1[Project.Models.AspNetUser]' cannot be called with instance of type 'System.Data.Entity.Core.Objects.ObjectQuery1[Project.Models.AspNetUser]'

Alex Art. · Accepted Answer · 2015-08-31 08:21:36Z

2

Discussion_CreateBy = db.AspNetUsers.Find(discussion.CreatedBy).UserName

Works because discussion is an in-memory object because you are executing a query by calling FirstOrDefault on it:

var discussion = db.AB_Discussion.Where(d => d.Discussion_ID == Discussion_ID).FirstOrDefault();

On the other hand in the following statement:

db.AspNetUsers.Find(c.CreatedBy).UserName

c is not queried yet because

db.AB_DiscussionComments.Where(c => c.Discussion_ID == Discussion_ID)

returns an IQueriable and not the actual collection of comments

The easiest way to fix it is to bring all your comments into memory (since you are anyway need them all) :

var comments = db.AB_DiscussionComments.Where(c => c.Discussion_ID == Discussion_ID).ToList();

answered Aug 31, 2015 at 8:21

Alex Art.

8,7813 gold badges32 silver badges50 bronze badges

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

3 Comments

Chathz Over a year ago

as you said I chaned that code snippet , then what should I refer for code snippet does it change also Comment_CreateBy = db.AspNetUsers.Find(c.CreatedBy).UserName

Alex Art. Over a year ago

The only change you need to do is : var comments = db.AB_DiscussionComments.Where(c => c.Discussion_ID == Discussion_ID).ToList();

Chathz Over a year ago

you're genius thnks lot

Collectives™ on Stack Overflow

cannot be called with instance of type 'System.Data.Entity.Core.Objects.ObjectQuery

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related