Could not find an implementation of the query pattern

by

Is the tblPersoon implementing IEnumerable<T>? You may need to do it using:

var query = (from p in tblPersoon.Cast<Person>() select p).Single();

This kind of error (Could not find an implementation of the query pattern) usually occurs when:

  • You are missing LINQ namespace usage (using System.Linq)
  • Type you are querying does not implement IEnumerable<T>

Edit:

Apart from fact you query type (tblPersoon) instead of property tblPersoons, you also need an context instance (class that defines tblPersoons property), like this: 

public tblPersoon GetPersoonByID(string id)
{
    var context = new DataClasses1DataContext();
    var query = context.tblPersoons.Where(p => p.id == id).Single();
    // ...

More Related Contents:

  1. convert sql query into lambda expression [closed]
  2. LINQ to Entities does not recognize the method ‘System.String ToString()’ method, and this method cannot be translated into a store expression
  3. Is there a good LINQ way to do a cartesian product?
  4. LINQ to SQL – Left Outer Join with multiple join conditions
  5. linq case statement
  6. LINQ to SQL multiple tables left outer join
  7. Equivalent of SQL ISNULL in LINQ?
  8. Distinct in Linq based on only one field of the table
  9. Wildcard search for LINQ
  10. Get an IDataReader from a typed List
  11. Local sequence cannot be used in LINQ to SQL implementation of query operators except the Contains() operator
  12. Entity Framework. Delete all rows in table
  13. Use linq to generate direct update without select
  14. Join and Include in Entity Framework
  15. How to make LINQ execute a (SQL) LIKE range search
  16. WCF HttpTransport: streamed vs buffered TransferMode
  17. Calling a SQL User-defined function in a LINQ query
  18. Issues Doing a String Comparison in LINQ
  19. Convert SQL to LINQ Query [closed]
  20. Linq To Sql compare Time only
  21. Linq union usage?
  22. Performance loss caused by Linq [duplicate]
  23. How to do joins in LINQ on multiple fields in single join
  24. Sequence contains no elements?
  25. Determine if a sequence contains all elements of another sequence using Linq [duplicate]
  26. Combine two Linq lambda expressions
  27. ASP.NET 5 add WCF service reference
  28. LINQ to SQL in and not in
  29. LINQ to Entities group-by failure using .date
  30. Linq query or Lambda expression?

Leave a Comment