Join and Include in Entity Framework

by

Well, the Include contradicts the where. Include says, “Load all tags.” The where says, “Load some tags.” When there is a contradiction between the query and Include, the query will always win.

To return all tags from any item with at least one tag == text:

        var items = from i in db.Items.Include("Tags")
                    where i.Tags.Any(t => t.Text == text)
                    orderby i.CreatedDate descending
                    select i;

(Untested, as I don’t have your DB/model)

Here’s a really good, free book on LINQ.

More Related Contents:

  1. Linq: help me to make this work
  2. How do I apply OrderBy on an IQueryable using a string column name within a generic extension method?
  3. Why is .Contains slow? Most efficient way to get multiple entities by primary key?
  4. Entity Framework/Linq EXpression converting from string to int
  5. Filter/Search using Multiple Fields – ASP.NET MVC
  6. LINQ to SQL multiple tables left outer join
  7. Entity Framework. Delete all rows in table
  8. How to convert an expression tree to a partial SQL query?
  9. Use linq to generate direct update without select
  10. Retrieve an object from entityframework without ONE field
  11. Calling a SQL User-defined function in a LINQ query
  12. Max return value if empty query
  13. Remove item from list based on condition
  14. How to do an “in” query in entity framework?
  15. Issues Doing a String Comparison in LINQ
  16. Keep Getting ‘The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities’ Exception
  17. Linq Query keeps throwing “Unable to create a constant value of type System.Object….”, Why?
  18. How to include() nested child entity in linq
  19. Should the order of LINQ query clauses affect Entity Framework performance?
  20. LINQ Query to Convert string to datetime
  21. Get all checked nodes of a treeview
  22. Can I specify my explicit type comparator inline?
  23. How to compare only date components from DateTime in EF?
  24. Entity Framework – stored procedure return value
  25. LINQ to Entities does not recognize the method ‘System.Web.Mvc.FileResult’
  26. Can I split an IEnumerable into two by a boolean criteria without two queries?
  27. ef4 cause Circular reference in web service
  28. Linq Syntax – Selecting multiple columns
  29. Entity framework raw SQL Query
  30. Sql Bulk Copy/Insert in C#

Leave a Comment