diff options
| -rw-r--r-- | Emby.Server.Implementations/Data/BaseSqliteRepository.cs | 8 | ||||
| -rw-r--r-- | Emby.Server.Implementations/Data/ManagedConnection.cs | 8 |
2 files changed, 12 insertions, 4 deletions
diff --git a/Emby.Server.Implementations/Data/BaseSqliteRepository.cs b/Emby.Server.Implementations/Data/BaseSqliteRepository.cs index 450688491..b86511482 100644 --- a/Emby.Server.Implementations/Data/BaseSqliteRepository.cs +++ b/Emby.Server.Implementations/Data/BaseSqliteRepository.cs @@ -98,8 +98,16 @@ namespace Emby.Server.Implementations.Data /// <value>The write connection.</value> protected SQLiteDatabaseConnection WriteConnection { get; set; } + protected SQLiteDatabaseConnection ReadConnection { get; set; } + protected ManagedConnection GetConnection(bool readOnly = false) { + if (readOnly) + { + ReadConnection ??= SQLite3.Open(DbFilePath, ConnectionFlags.ReadOnly, null); + return new ManagedConnection(ReadConnection, null); + } + WriteLock.Wait(); if (WriteConnection != null) { diff --git a/Emby.Server.Implementations/Data/ManagedConnection.cs b/Emby.Server.Implementations/Data/ManagedConnection.cs index 11e33278d..fe09bdc2a 100644 --- a/Emby.Server.Implementations/Data/ManagedConnection.cs +++ b/Emby.Server.Implementations/Data/ManagedConnection.cs @@ -9,13 +9,13 @@ namespace Emby.Server.Implementations.Data { public sealed class ManagedConnection : IDisposable { - private readonly SemaphoreSlim _writeLock; + private readonly SemaphoreSlim? _writeLock; private SQLiteDatabaseConnection? _db; - private bool _disposed = false; + private bool _disposed; - public ManagedConnection(SQLiteDatabaseConnection db, SemaphoreSlim writeLock) + public ManagedConnection(SQLiteDatabaseConnection db, SemaphoreSlim? writeLock) { _db = db; _writeLock = writeLock; @@ -73,7 +73,7 @@ namespace Emby.Server.Implementations.Data return; } - _writeLock.Release(); + _writeLock?.Release(); _db = null; // Don't dispose it _disposed = true; |