Expose loader IQueryable on ILazyLoader
Nobody has claimed this yet.
Assessment
- Difficulty
- 5/5
- Estimated time
- Over a week
- Newbie friendliness
- 25/100
Research direction
Start by reviewing ILazyLoader and its Load method in the EF Core 3.1.1 codebase, with the Lesson and Topics example as the usage case. Determine the API needed to expose an IQueryable for a lazy-loaded collection and verify that an IsValid filter can be applied at the database level through the SQL Server provider.
Written by the indexing model from the issue text.
Description
Hi,
I have entity which contains other entities inside. I'm using ILazyLoader to load them when needed, but I want to filter them. How can I filter them?
Lets say I have:
public class Lesson : EntityBase
{
private readonly ILazyLoader _lazyLoader;
public Lesson(ILazyLoader lazyLoader)
{
_lazyLoader = lazyLoader;
}
[Required]
public List<Topic> Topics
{
get => _lazyLoader.Load(this, ref _topics);
set => _topics = value;
}
private List<Topic> _topics;
I want to access lesson.Grades, but my grades should be filtered by IsValid field.
At the moment it will load all the grades.
I understand I can do _lazyLoader.Load(this, ref _topics).Where(x => x.IsValid).ToList();, but I want filter in database level
Is this possible?
Include provider and version information
EF Core version: 3.1.1
Database provider: Microsoft.EntityFrameworkCore.SqlServer
Target framework: Core 3.1
- Dominant language
- C#
- Stars
- 14.8k
- Forks
- 3.4k
- Avg merge
- 2d 5h
- Merged PRs (30d)
- 134
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from dotnet/efcore
-
Difficulty 4/5 3-5 days Newbie friendliness 55/100
-
customer-reported
Difficulty 5/5 Over a week Newbie friendliness 38/100
-
area-cosmos area-vector-search
Difficulty 5/5 Over a week Newbie friendliness 25/100
-
area-cosmos
Difficulty 5/5 Over a week Newbie friendliness 25/100
-
area-tools needs-design
Difficulty 4/5 3-5 days Newbie friendliness 25/100
Similar issues
-
Difficulty 2/5 1-3 hours Newbie friendliness 86/100
-
:watch: Not Triaged 11.0 fundamentals/subsvc
Difficulty 2/5 1-3 hours Newbie friendliness 92/100
dotnet/AspNetCore.Docs#37699 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
SubtitleEdit/subtitleedit#15108 · 1 comment ·
-
area/docs-content Bug pulumi/docs
Difficulty 1/5 1-3 hours Newbie friendliness 94/100
-
agentic-workflows untriaged
Difficulty 2/5 1-3 hours Newbie friendliness 76/100