From 5996c4afce11249804d24f1caa3a99b390543c4d Mon Sep 17 00:00:00 2001
From: Shadowghost <Ghost_of_Stone@web.de>
Date: Sat, 17 Jan 2026 17:10:07 +0100
Subject: Complete LinkedChildren integration and batch DTO optimizations

This commit integrates remaining performance changes:

- Add batch user data fetching in DtoService to reduce N+1 queries
- Add GetNextUpEpisodesBatch in TVSeriesManager for efficient batch retrieval
- Update Video/Movie/BoxSet to use LibraryManager for alternate versions
- Transition LinkedChild to use ItemId instead of Path (obsolete Path/LibraryItemId)
- Update providers and controllers for LinkedChildren-based references
- Add NextUpEpisodeBatchResult for batched episode queries
- Integrate IDescendantQueryProvider in SqliteDatabaseProvider
---
 .../Jellyfin.Database.Implementations/IJellyfinDatabaseProvider.cs  | 6 ++++++
 1 file changed, 6 insertions(+)

(limited to 'src/Jellyfin.Database/Jellyfin.Database.Implementations')

diff --git a/src/Jellyfin.Database/Jellyfin.Database.Implementations/IJellyfinDatabaseProvider.cs b/src/Jellyfin.Database/Jellyfin.Database.Implementations/IJellyfinDatabaseProvider.cs
index 27dbeaba6a..f52a68c684 100644
--- a/src/Jellyfin.Database/Jellyfin.Database.Implementations/IJellyfinDatabaseProvider.cs
+++ b/src/Jellyfin.Database/Jellyfin.Database.Implementations/IJellyfinDatabaseProvider.cs
@@ -17,6 +17,12 @@ public interface IJellyfinDatabaseProvider
     /// </summary>
     IDbContextFactory<JellyfinDbContext>? DbContextFactory { get; set; }
 
+    /// <summary>
+    /// Gets the descendant query provider for this database type.
+    /// Used for recursive CTE queries to find all descendants of an item.
+    /// </summary>
+    IDescendantQueryProvider DescendantQueryProvider { get; }
+
     /// <summary>
     /// Initialises jellyfins EFCore database access.
     /// </summary>
-- 
cgit v1.2.3