conditional include in linq to entities?

by

This should do the trick:

using (TestEntities db = new TestEntities())
{
    var query = from d in db.Dealership
                select new
                {
                    Dealer = d,
                    Parts = d.Part.Where
                    (
                        p => p.Price < 100.0 
                             && p.Supplier.Country == "Brazil"
                    ),
                    Suppliers = d.Part.Select(p => p.Supplier)
                };

    var dealers = query.ToArray().Select(o => o.Dealer);
    foreach (var dealer in dealers)
    {
        Console.WriteLine(dealer.Name);
        foreach (var part in dealer.Part)
        {
            Console.WriteLine("  " + part.PartId + ", " + part.Price);
            Console.WriteLine
                (
                "  " 
                + part.Supplier.Name 
                + ", " 
                + part.Supplier.Country
                );
        }
    }
}

This code will give you a list of Dealerships each containing a filtered list of parts. Each part references a Supplier. The interesting part is that you have to create the anonymous types in the select in the way shown. Otherwise the Part property of the Dealership objects will be empty.

Also, you have to execute the SQL statement before selecting the dealers from the query. Otherwise the Part property of the dealers will again be empty. That is why I put the ToArray() call in the following line:

var dealers = query.ToArray().Select(o => o.Dealer);

But I agree with Darren that this may not be what the users of your library are expecting.

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. Only initializers, entity members, and entity navigation properties are supported
  7. Convert String to Int in EF 4.0
  8. Linq-to-entities – Include() method not loading
  9. Entity Framework – “Unable to create a constant value of type ‘Closure type’…” error
  10. Instantiating a context 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. Dynamic where clause (OR) in Linq to Entities
  17. Why doesn’t Include have any effect?
  18. Value cannot be null. Parameter name: source
  19. Recursive Hierarchy – Recursive Query using Linq
  20. Filter/Search using Multiple Fields – ASP.NET MVC
  21. EF LINQ include multiple and nested entities
  22. The result of a query cannot be enumerated more than once
  23. How to use LINQ in C++/CLI – in VS 2010/.Net 4.0
  24. Entity-framework code is slow when using Include() many times
  25. The operation cannot be completed because the DbContext has been disposed using MVC 4
  26. How does LINQ expression syntax work with Include() for eager loading
  27. Linq To Sql – Dynamic OrderBy – Case When
  28. Entity Framework 4 Single() vs First() vs FirstOrDefault()
  29. Dynamic query with OR conditions in Entity Framework
  30. Only primitive types or enumeration types are supported in this context

Leave a Comment