Only initializers, entity members, and entity navigation properties are supported

by

Entity is trying to convert your Paid property to SQL and can’t because it’s not part of the table schema.

What you can do is let Entity query the table with no Paid filter and then filter out the not Paid ones.

public ActionResult Index()
{
    var debts = storeDB.Orders
        //.Where(o => o.Paid == false)
        .OrderByDescending(o => o.DateCreated);

    debts = debts.Where(o => o.Paid == false);

    return View(debts);
}

That, of course, would mean that you bringing all of the data back to the web server and filtering the data on it. If you want to filter on the DB server, you can create a Calculated Column on the table or use a Stored Procedure.

More Related Contents:

  1. Entity Framework: There is already an open DataReader associated with this Command
  2. Linq: adding conditions to the where clause conditionally
  3. Entity framework linq query Include() multiple children entities
  4. How to filter nested collection Entity Framework objects?
  5. LINQ to Entities does not recognize the method ‘System.String Format(System.String, System.Object, System.Object)’
  6. Convert String to Int in EF 4.0
  7. Linq-to-entities – Include() method not loading
  8. Entity Framework – “Unable to create a constant value of type ‘Closure type’…” error
  9. Instantiating a context in LINQ to Entities
  10. conditional include in linq to entities?
  11. EF 4: Removing child object from collection does not delete it – why?
  12. Linq To Entities – how to filter on child entities
  13. Entity Framework, Code First and Full Text Search
  14. LINQ OrderBy not ordering .. changing nothing .. why?
  15. Simple Linq query has duplicated join against same table?
  16. ‘Contains()’ workaround using Linq to Entities?
  17. How to use a string to create a EF order by expression?
  18. System.LINQ.Dynamic: Select(” new (…)”) into a List (or any other enumerable collection of )
  19. Standard Deviation in LINQ
  20. How To Project a Line Number Into Linq Query Results
  21. Calculate difference from previous item with LINQ
  22. LINQ with SQLite (linqtosql)
  23. How to create a dynamic LINQ join extension method
  24. Dynamic table name in linq [duplicate]
  25. Join and Include in Entity Framework
  26. Creating dynamic queries with entity framework
  27. Linq to SQL how to do “where [column] in (list of values)”
  28. Remove item from list based on condition
  29. How to group by DateTime.Date in EntityFramework
  30. LINQ: How to convert the nested hierarchical object to flatten object

Leave a Comment