LINQ to Entities does not recognize the method ‘System.String Format(System.String, System.Object, System.Object)’

by

Entity Framework is trying to execute your projection on the SQL side, where there is no equivalent to string.Format. Use AsEnumerable() to force evaluation of that part with Linq to Objects.

Based on the previous answer I have given you I would restructure your query like this:

int statusReceived = (int)InvoiceStatuses.Received;
var areaIds = user.Areas.Select(x=> x.AreaId).ToArray();

var taskList = (from i in _db.Invoices
               where i.Status == statusReceived && areaIds.Contains(i.AreaId)
               select i)
               .AsEnumerable()
               .Select( x => new Task()
               {
                  LinkText = string.Format("Invoice {0} has been received from {1}", x.InvoiceNumber, x.Organisation.Name),
                  Link = Views.Edit
                });

Also I see you use related entities in the query (Organisation.Name) make sure you add the proper Include to your query, or specifically materialize those properties for later use, i.e.:

var taskList = (from i in _db.Invoices
               where i.Status == statusReceived && areaIds.Contains(i.AreaId)
               select new { i.InvoiceNumber, OrganisationName = i.Organisation.Name})
               .AsEnumerable()
               .Select( x => new Task()
               {
                  LinkText = string.Format("Invoice {0} has been received from {1}", x.InvoiceNumber, x.OrganisationName),
                  Link = Views.Edit
                });

More Related Contents:

  1. Convert String to Int in EF 4.0
  2. Instantiating a context in LINQ to Entities
  3. Linq To Entities – how to filter on child entities
  4. LINQ to Entities does not recognize the method
  5. How to create LINQ Expression Tree to select an anonymous type
  6. ‘Contains()’ workaround using Linq to Entities?
  7. Entity Framework: There is already an open DataReader associated with this Command
  8. How many Include I can use on ObjectSet in EntityFramework to retain performance?
  9. Entity framework linq query Include() multiple children entities
  10. “A lambda expression with a statement body cannot be converted to an expression tree”
  11. Bulk-deleting in LINQ to Entities
  12. The type of one of the expressions in the join clause is incorrect in Entity Framework
  13. Entity framework left join
  14. LEFT JOIN in LINQ to entities?
  15. Learning about LINQ [closed]
  16. How to compare only date components from DateTime in EF?
  17. “The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities” – stumped!
  18. Linq-to-entities – Include() method not loading
  19. Entity Framework – “Unable to create a constant value of type ‘Closure type’…” error
  20. How to create a dynamic LINQ join extension method
  21. conditional include in linq to entities?
  22. EF 4: Removing child object from collection does not delete it – why?
  23. Linq to Entity Join table with multiple OR conditions
  24. The specified type member ‘Date’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties
  25. ‘Date’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported
  26. Entity Framework, Code First and Full Text Search
  27. LINQ OrderBy not ordering .. changing nothing .. why?
  28. Calling a SQL User-defined function in a LINQ query
  29. Simple Linq query has duplicated join against same table?
  30. How to avoid Query Plan re-compilation when using IEnumerable.Contains in Entity Framework LINQ queries?

Leave a Comment