aboutsummaryrefslogtreecommitdiff
path: root/MediaBrowser.Server.Implementations/Sqlite/SQLiteUserRepository.cs
diff options
context:
space:
mode:
authorLuke Pulverenti <luke.pulverenti@gmail.com>2013-05-21 11:52:59 -0400
committerLuke Pulverenti <luke.pulverenti@gmail.com>2013-05-21 11:52:59 -0400
commite01202030dcd16cd9c7c3327b4e411be7de02614 (patch)
tree1f905a3471d6e2f9f6e241f491da5c51f2021e47 /MediaBrowser.Server.Implementations/Sqlite/SQLiteUserRepository.cs
parent8682ee30dd8d1d654c79467bd5c0939c7339f214 (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.cs20
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);