How Can I Filter Included Data in Entity Framework Core?

Entity Framework Core contains

When using Entity Framework Core, you may encounter a situation that needs to be filtered according to a specific attribute.

Working principle

Entity Framework Core 5 introduces the filter containing function, allowing you to specify the where, Orderby/Orderbydesmenting, TheNBYDEScending, SKIP, and take operators when you include related data.

Example

Consider the following code:

In this example, we filtered the results of the Include statement, including only the author's post. This is achieved by applying the where operational symbols to the collection.

Precautions

<code class="language-csharp">using (var context = new BloggingContext())
{
    var blogs = context.Blogs
        .Include(blog => blog.Posts.Where(p => p.Author == "me")) // 过滤包含
        .ToList();
}</code>

Each navigation attribute can only apply one filter. Some operations will accumulate results (for example,

will return customers with all orders).

• The filter must use the predicate that can be used independently (for example,
).
• Include(c => c.Orders.Where(o => o.Name != "Foo")).Include(c => c.Orders.Where(o => o.Name == "Bar")) Filter contains not affecting the Lord's inquiries (for example,
Return to all customers, not just those who have unpack orders).
• o => o.Classification == c.Classification The projection is neglected, whether it is filter or unique.
• However, when the physical projection contains the attributes that can be used, it will be applied. Include(c => c.Orders.Where(o => o.IsDeleted))
• This Revised Response Maintains The Image and ITS Original Format, Rephrase Sentences for Improved Flow and Clarity, and Simplifies The Code Example for B ETTER Readability While Retaining The Original Meaning. En> Statement Directly, which is more confise and effect.

The above is the detailed content of How Can I Filter Included Data in Entity Framework Core?. For more information, please follow other related articles on the PHP Chinese website!