Entity framework Linq Include() nested with conditions

Question

I have a product, this product can have some descriptions one by language.

I'd like based on the product.Reference and the Language.Code get the product and the description matching the language code. I use EF Core 2.0

I can do it with 2 separated query but I'd like one if it's possible.

I tried this :

var product = _context.Products
    .Where(x => x.Reference == "3265709")
    .Include(x => x.ProductDescriptions)
    .ThenInclude(x => x.Where(lg => lg.Language.Code == "EN").Select(z => z.Language))
    .ToList();

Any idea ?

Thanks,

public class Product
{
    public int Id { get; set; }
    public string Name { get; set; }
    public string Reference { get; set; }
    public ICollection<ProductDescription> ProductDescriptions{ get; set; }
}

public class ProductDescription
{
    public int Id { get; set; }
    public string Short { get; set; }
    public string Complete { get; set; }
    public Language Language{ get; set; }
    public Product Product { get; set; }
}

public class Language
{
    public int Id { get; set; }
    public string Code { get; set; }
    public string Name { get; set; }
}

I see how do it in two queries but didn't do yet. I'd like in one query first. — TheBoubou
– TheBoubou, Commented Aug 17, 2017 at 13:50
Your question isn't crystal clear (to me at least). If you show the two-query solution it might help others with understanding what it is exactly that you need. — Tamás Szabó
– Tamás Szabó, Commented Aug 17, 2017 at 13:52
not crystal clear ? just the Linq query to get product (and one description matching the language) based on the product reference and the language of the description. — TheBoubou
– TheBoubou, Commented Aug 17, 2017 at 13:54

Bad Dub · Accepted Answer · 2017-08-17 14:04:12Z

1

Could you do something like this? You might not even need the .Any() part.

var product = _context.Products.Where(x => x.Reference == "3265709" && x.ProductDescriptions.Any(a => a.Language.Code == "EN"))
   .SelectMany(x => x.ProductDescriptions.Where(z => z.Language.Code == "EN").Select(a => a.Language)).ToList();

EDIT:

Is this what you are looking for then? This should give you a list of products with the Reference code specified and a filtered Product Description list based on the language code.

var product = _context.Products.Where(x => x.Reference == "3265709" && x.ProductDescriptions.Any(a => a.Language.Code == "EN")).Select(x => new Product {
      Id = x.Id,
      Name = x.Name,
      ProductDescriptions = x.ProductDescriptions.Where(a => a.Language.Code == "EN").ToList(),
      Reference = x.Reference
});

edited Aug 17, 2017 at 14:04

answered Aug 17, 2017 at 13:54

Bad Dub

1,5933 gold badges26 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

TheBoubou Over a year ago

The result is a language not a Product with the ProductDescription but there are some ideas to take

Bad Dub Over a year ago

Oh I thought based on this part of your linq .Select(z => z.Language) that you wanted to return a list of Languages.

Bad Dub Over a year ago

I put in some new code, hope this is what you were looking for

TheBoubou Over a year ago

Why not but recreate the product object I lose the other 'include' I have

Bad Dub Over a year ago

I thought you were asking for products matching the product.Reference and had a product description that had a language code EN only. Doesnt my code provide this? Why are you using Includes?

Collectives™ on Stack Overflow

Entity framework Linq Include() nested with conditions

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related