Local sequence cannot be used in LINQ to SQL implementation of query operators except the Contains() operator

by

You can’t use a Join between a SQL source and a local source. You’ll need to bring the SQL data into memory before you can join them. In this case, you’re not really doing a join since you only take the elements from the first collection, what you want is a select…where…selectid in query, which you can get using the Contains method.

 var SE = Shop.Sections.Where( s => obj.SectionObjects
                                       .Select( so => so.SectionId )
                                       .Contains( s.SectionId ))
                       .ToList();

Translates to

select * from Sections where sectionId in (...)

where the values for the in clause come from the list of ids in the collection of local objects.

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. Could not find an implementation of the query pattern
  10. Wildcard search for LINQ
  11. Get an IDataReader from a typed List
  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. Calling a SQL User-defined function in a LINQ query
  17. Issues Doing a String Comparison in LINQ
  18. Convert SQL to LINQ Query [closed]
  19. Linq To Sql compare Time only
  20. Linq union usage?
  21. How concat where in linq [closed]
  22. linq syntax: What is the type that this returns? How can I now go ahead and use firstRow.ingredientName etc?
  23. How to use the Except in C# [closed]
  24. When to use .First and when to use .FirstOrDefault with LINQ?
  25. printing all contents of array in C#
  26. Entering keys manually with Entity Framework
  27. Insert entire DataTable into database at once instead of row by row?
  28. How to get the index of an element in an IEnumerable?
  29. DropdownList DataSource
  30. How to Bulk Update records in Entity Framework?

Leave a Comment