aboutsummaryrefslogtreecommitdiff
path: root/Emby.Server.Implementations/Data/SqliteUserRepository.cs
diff options
context:
space:
mode:
Diffstat (limited to 'Emby.Server.Implementations/Data/SqliteUserRepository.cs')
-rw-r--r--Emby.Server.Implementations/Data/SqliteUserRepository.cs20
1 files changed, 11 insertions, 9 deletions
diff --git a/Emby.Server.Implementations/Data/SqliteUserRepository.cs b/Emby.Server.Implementations/Data/SqliteUserRepository.cs
index f0e38f8c0..ee496b669 100644
--- a/Emby.Server.Implementations/Data/SqliteUserRepository.cs
+++ b/Emby.Server.Implementations/Data/SqliteUserRepository.cs
@@ -89,11 +89,12 @@ namespace Emby.Server.Implementations.Data
{
connection.RunInTransaction(db =>
{
- var commandText = "replace into users (guid, data) values (?, ?)";
-
- db.Execute(commandText,
- user.Id.ToGuidParamValue(),
- serialized);
+ using (var statement = db.PrepareStatement("replace into users (guid, data) values (@guid, @data)"))
+ {
+ statement.BindParameters.TryBind("@guid", user.Id.ToGuidParamValue());
+ statement.BindParameters.TryBind("@data", serialized);
+ statement.MoveNext();
+ }
});
}
}
@@ -151,10 +152,11 @@ namespace Emby.Server.Implementations.Data
{
connection.RunInTransaction(db =>
{
- var commandText = "delete from users where guid=?";
-
- db.Execute(commandText,
- user.Id.ToGuidParamValue());
+ using (var statement = db.PrepareStatement("delete from users where guid=@id"))
+ {
+ statement.BindParameters.TryBind("@id", user.Id.ToGuidParamValue());
+ statement.MoveNext();
+ }
});
}
}