LINQ to Entities does not recognize the method ‘System.Web.Mvc.FileResult’

by

GetFileData couldn’t be translated to T-SQL, Linq to Entities couldn’t recognize it. You can modify the code as below (Move the GetFileData out of expression):

var pic = GetFileData(user.Id);

public JsonResult GetUsers()
{
    var ret = (from user in db.Users
               orderby user.UserName
               select new
               {
                   UserName = user.UserName,
                   Pic = pic,
               }).AsEnumerable();
    return Json(ret, JsonRequestBehavior.AllowGet);
}

But because user does not exist outside the query you should use .ToList() to defer the use of your function. With .ToList() after data is loaded, any further operation (such as select) is performed using Linq to Objects, on the data already in memory. So your query should be like this:

public JsonResult GetUsers()
{
    var ret = (from user in db.Users.ToList()
               orderby user.UserName
               select new
               {
                   UserName = user.UserName,
                   Pic = GetFileData(user.Id),
               }).AsEnumerable();
    return Json(ret, JsonRequestBehavior.AllowGet);
}

More Related Contents:

  1. Filter/Search using Multiple Fields – ASP.NET MVC
  2. How to group by on 2 child entities and get total of both this child entities?
  3. The operation cannot be completed because the DbContext has been disposed using MVC 4
  4. Export Model to DataTable
  5. Only primitive types or enumeration types are supported in this context
  6. Linq: help me to make this work
  7. How to post an array of complex objects with JSON, jQuery to ASP.NET MVC Controller?
  8. Web API Put Request generates an Http 405 Method Not Allowed error
  9. Writing Recursive CTE using Entity Framework Fluent syntax or Inline syntax
  10. Validation failed for one or more entities while saving changes to SQL Server Database using Entity Framework
  11. Posting JSON Data to ASP.NET MVC
  12. LEFT JOIN in LINQ to entities?
  13. Linq to EntityFramework DateTime
  14. LINQ to SQL multiple tables left outer join
  15. Entity Framework (.NET Full Framework) Ordering Includes [duplicate]
  16. How to flatten an ExpandoObject returned via JsonResult in asp.net mvc?
  17. How to compare only date components from DateTime in EF?
  18. How to Bulk Update records in Entity Framework?
  19. Entity Framework 6 Code First Custom Functions
  20. When should I create a new DbContext()
  21. LINQ, Unable to create a constant value of type XXX. Only primitive types or enumeration types are supported in this context
  22. Can I LINQ a JSON?
  23. Return “raw” json in ASP.NET Core 2.0 Web Api
  24. Entity vs Model vs View Model
  25. C# Entity-Framework: How can I combine a .Find and .Include on a Model Object?
  26. ‘Date’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported
  27. Return JSON with error status code MVC
  28. Post JSON array to mvc controller
  29. How to wrap Entity Framework to intercept the LINQ expression just before execution?
  30. Entity Framework Many to many through containing object

Leave a Comment