ASP.NET MVC EntityFramework: how to use LINQ inside ActionResult controller method?

Question

[HttpPost]
    public ActionResult RemoveCollaborationEntry(int collaborationEntryID = 0)
    {
        using (var collaborationEntriesContext = new CollaborationEntryContext())
        {
            collaborationEntriesContext.Collaborations.Remove(
                collaborationEntriesContext.Collaborations.ElementAtOrDefault(collaborationEntryID));

            collaborationEntriesContext.SaveChanges();               
        }

        return RedirectToAction(nameof(Index));
    }

When this method gets invoked, the exception is torwn:

LINQ to Entities does not recognize the method 'annaBevzenkoPortfolioMVC.AboutMe.CollaborationEntry ElementAtOrDefault[CollaborationEntry](System.Linq.IQueryable`1[annaBevzenkoPortfolioMVC.AboutMe.CollaborationEntry], Int32)' method, and this method cannot be translated into a store expression.

I am pretty new to Entity.. can someone help me?

Make sure you bring in the System.Linq namespace so it can find the extension method ElementAtOrDefault. — Bradley Uffner
– Bradley Uffner, Commented May 5, 2016 at 19:40

CodeNotFound · Accepted Answer · 2016-05-05 19:41:02Z

3

Entity Framewok does not know how to translate into SQL Query the follwoing method ElementAtOrDefault.

You need to use Find method by doing the code below:

collaborationEntriesContext.Collaborations.Find(collaborationEntryID)

answered May 5, 2016 at 19:41

CodeNotFound

23.4k10 gold badges75 silver badges73 bronze badges

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

5 Comments

52hertz Over a year ago

Really? Consider this link entityframeworktutorial.net/…. There is the example using ElementAt(int).

CodeNotFound Over a year ago

But this instruction studentList.ElementAt<Student>(0) is applied on a Linq TO Objects studentList not on a DbSet<Student> :)

CodeNotFound Over a year ago

var studentList = context.Students.ToList<Student>(); sudentList here is a collection of Object not and DbSet<Student>() because of ToList()

CodeNotFound Over a year ago

Mark it as an answer if this answer satisfied you, please :)

52hertz Over a year ago

I am waiting for 2 minutes more to do that.

Collectives™ on Stack Overflow

ASP.NET MVC EntityFramework: how to use LINQ inside ActionResult controller method?

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related