diff options
| author | Luke Pulverenti <luke.pulverenti@gmail.com> | 2013-05-21 11:52:59 -0400 |
|---|---|---|
| committer | Luke Pulverenti <luke.pulverenti@gmail.com> | 2013-05-21 11:52:59 -0400 |
| commit | e01202030dcd16cd9c7c3327b4e411be7de02614 (patch) | |
| tree | 1f905a3471d6e2f9f6e241f491da5c51f2021e47 /MediaBrowser.Server.Implementations/Sqlite/SQLiteUserRepository.cs | |
| parent | 8682ee30dd8d1d654c79467bd5c0939c7339f214 (diff) | |
removed sql delayed writer in favor of prepared statements
Diffstat (limited to 'MediaBrowser.Server.Implementations/Sqlite/SQLiteUserRepository.cs')
| -rw-r--r-- | MediaBrowser.Server.Implementations/Sqlite/SQLiteUserRepository.cs | 20 |
1 files changed, 4 insertions, 16 deletions
diff --git a/MediaBrowser.Server.Implementations/Sqlite/SQLiteUserRepository.cs b/MediaBrowser.Server.Implementations/Sqlite/SQLiteUserRepository.cs index eb5868932..baaf9d956 100644 --- a/MediaBrowser.Server.Implementations/Sqlite/SQLiteUserRepository.cs +++ b/MediaBrowser.Server.Implementations/Sqlite/SQLiteUserRepository.cs @@ -46,18 +46,6 @@ namespace MediaBrowser.Server.Implementations.Sqlite private readonly IApplicationPaths _appPaths; /// <summary> - /// Gets a value indicating whether [enable delayed commands]. - /// </summary> - /// <value><c>true</c> if [enable delayed commands]; otherwise, <c>false</c>.</value> - protected override bool EnableDelayedCommands - { - get - { - return false; - } - } - - /// <summary> /// Initializes a new instance of the <see cref="SQLiteUserDataRepository" /> class. /// </summary> /// <param name="appPaths">The app paths.</param> @@ -127,13 +115,13 @@ namespace MediaBrowser.Server.Implementations.Sqlite cancellationToken.ThrowIfCancellationRequested(); - using (var cmd = connection.CreateCommand()) + using (var cmd = Connection.CreateCommand()) { cmd.CommandText = "replace into users (guid, data) values (@1, @2)"; cmd.AddParam("@1", user.Id); cmd.AddParam("@2", serialized); - using (var tran = connection.BeginTransaction()) + using (var tran = Connection.BeginTransaction()) { try { @@ -162,7 +150,7 @@ namespace MediaBrowser.Server.Implementations.Sqlite /// <returns>IEnumerable{User}.</returns> public IEnumerable<User> RetrieveAllUsers() { - using (var cmd = connection.CreateCommand()) + using (var cmd = Connection.CreateCommand()) { cmd.CommandText = "select data from users"; @@ -201,7 +189,7 @@ namespace MediaBrowser.Server.Implementations.Sqlite cancellationToken.ThrowIfCancellationRequested(); - using (var cmd = connection.CreateCommand()) + using (var cmd = Connection.CreateCommand()) { cmd.CommandText = "delete from users where guid=@guid"; var guidParam = cmd.Parameters.Add("@guid", DbType.Guid); |
