Data binding directly to a store query (DbSet, DbQuery, DbSqlQuery) is not supported

by

The error is fairly clear – you can’t bind directly to the query results, but need to populate some local collection instead.

The simplest way to do this is to convert it to a List<T>, via ToList():

 ddlCon.DataSource = (from em in dw.Employees
                             select new { em.Title, em.EmployeeID }).ToList();

More Related Contents:

  1. What is the effect of AsEnumerable() on a LINQ Entity?
  2. LINQ to Entities does not recognize the method ‘Int32 Parse(System.String)’ method, and this method cannot be translated into a store expression
  3. How to make a tabbed window as in the picture using Visual C# (Studio 2010)
  4. Get all checked nodes of a treeview
  5. Display lines number in Stack Trace for .NET assembly in Release mode
  6. Distinct by property of class with LINQ [duplicate]
  7. Why is “Set as Startup” option stored in the suo file and not the sln file?
  8. C# – code to order by a property using the property name as a string [duplicate]
  9. How to get values from IGrouping
  10. LEFT JOIN in LINQ to entities?
  11. Combining multiple Attributes to a single Attribute – Merge Attributes
  12. Can I specify my explicit type comparator inline?
  13. Find the most occurring number in a List
  14. Entity Framework (.NET Full Framework) Ordering Includes [duplicate]
  15. How to compare only date components from DateTime in EF?
  16. Entity Framework 6 Code First Custom Functions
  17. Breakpoint Failed to Bind – Visual Studio 2015
  18. Visual Studio 2013 doesn’t discover unit tests
  19. EF migration for changing data type of columns
  20. how do I chunk an enumerable?
  21. Code equivalent to the ‘let’ keyword in chained LINQ extension method calls
  22. Symbol file not loading for debugging custom project in Visual Studio 2012
  23. Select all columns after JOIN in LINQ
  24. Visual Studio: auto attach to a process when the process is spawned
  25. How to set property value using Expressions? [duplicate]
  26. How do I default Visual Studio to C# projects instead of VB.NET?
  27. Should the order of LINQ query clauses affect Entity Framework performance?
  28. Transform IEnumerable asynchronously by awaiting each task
  29. How do I resolve the value of a databinding inside a MarkupExtension?
  30. Can I use Linq’s Except() with a lambda expression comparer?

Leave a Comment