nathan-parkinson / linq2db.include Goto Github PK

[Association(ThisKey = nameof(Id), OtherKey = nameof(Child.ParentId))]
public List<Child> Children { get; set; } = new List<Child>();

[Association(ThisKey = nameof(Id), OtherKey = nameof(Child.ParentId))]
public IEnumerable<Child> Children { get; set; } = new List<Child>();

var commentsHierarchyCteAns = _commentsLinq2DbContext.GetCte<Comment>(commentHierarchy =>
        {
            return _commentsLinq2DbContext.GetTable<Comment>()
                .Concat
                (
                    from c in _commentsLinq2DbContext.GetTable<Comment>()
                    from c2 in commentHierarchy.InnerJoin(eh => c.Id == eh.ParentId)
                    select c
                );
        });
var commentsHierarchyCteDes = _commentsLinq2DbContext.GetCte<Comment>(commentHierarchy =>
        {
            return _commentsLinq2DbContext.GetTable<Comment>()
                .Concat
                (
                    from c in _commentsLinq2DbContext.GetTable<Comment>()
                    from c2 in commentHierarchy.InnerJoin(eh => c.ParentId == eh.Id)
                    select c
                );
        });

var result = commentsHierarchyCteAns.Union(commentsHierarchyCteDes);

var resultList = result.Include(c => c.Files).ToList();