From 2c2e33dd82de89ce2bc0fe664f5c753e42a716bc Mon Sep 17 00:00:00 2001 From: JPVenson Date: Wed, 9 Oct 2024 23:58:55 +0000 Subject: Updated .AsNoTracking() where applicable --- Jellyfin.Server.Implementations/Item/BaseItemRepository.cs | 11 ++++++----- 1 file changed, 6 insertions(+), 5 deletions(-) (limited to 'Jellyfin.Server.Implementations/Item/BaseItemRepository.cs') diff --git a/Jellyfin.Server.Implementations/Item/BaseItemRepository.cs b/Jellyfin.Server.Implementations/Item/BaseItemRepository.cs index 702e72f0c..d42581ef4 100644 --- a/Jellyfin.Server.Implementations/Item/BaseItemRepository.cs +++ b/Jellyfin.Server.Implementations/Item/BaseItemRepository.cs @@ -233,7 +233,7 @@ public sealed class BaseItemRepository(IDbContextFactory dbPr var result = new QueryResult(); using var context = dbProvider.CreateDbContext(); - IQueryable dbQuery = context.BaseItems + IQueryable dbQuery = context.BaseItems.AsNoTracking() .Include(e => e.ExtraType) .Include(e => e.TrailerTypes) .Include(e => e.Images) @@ -272,7 +272,7 @@ public sealed class BaseItemRepository(IDbContextFactory dbPr PrepareFilterQuery(filter); using var context = dbProvider.CreateDbContext(); - var dbQuery = TranslateQuery(context.BaseItems, context, filter); + var dbQuery = TranslateQuery(context.BaseItems.AsNoTracking(), context, filter); if (filter.Limit.HasValue || filter.StartIndex.HasValue) { var offset = filter.StartIndex ?? 0; @@ -299,7 +299,7 @@ public sealed class BaseItemRepository(IDbContextFactory dbPr PrepareFilterQuery(filter); using var context = dbProvider.CreateDbContext(); - var dbQuery = TranslateQuery(context.BaseItems, context, filter); + var dbQuery = TranslateQuery(context.BaseItems.AsNoTracking(), context, filter); return dbQuery.Count(); } @@ -1310,7 +1310,7 @@ public sealed class BaseItemRepository(IDbContextFactory dbPr } using var context = dbProvider.CreateDbContext(); - var item = context.BaseItems.FirstOrDefault(e => e.Id == id); + var item = context.BaseItems.AsNoTracking().FirstOrDefault(e => e.Id == id); if (item is null) { return null; @@ -1644,6 +1644,7 @@ public sealed class BaseItemRepository(IDbContextFactory dbPr using var context = dbProvider.CreateDbContext(); var query = context.ItemValues + .AsNoTracking() .Where(e => itemValueTypes.Any(w => (ItemValueType)w == e.Type)); if (withItemTypes.Count > 0) { @@ -1693,7 +1694,7 @@ public sealed class BaseItemRepository(IDbContextFactory dbPr IsNews = filter.IsNews, IsSeries = filter.IsSeries }; - var query = TranslateQuery(context.BaseItems, context, innerQuery); + var query = TranslateQuery(context.BaseItems.AsNoTracking(), context, innerQuery); query = query.Where(e => e.Type == returnType && e.ItemValues!.Any(f => e.CleanName == f.CleanValue && itemValueTypes.Any(w => (ItemValueType)w == f.Type))); -- cgit v1.2.3