Increased DbManager commands timeout.

1 files changed, 7 insertions, 0 deletions

diff --git a/Software/Visual_Studio/Tango.Core/DB/DbManager.cs b/Software/Visual_Studio/Tango.Core/DB/DbManager.cs
index c23b6a39a..cc581ae3a 100644
--- a/Software/Visual_Studio/Tango.Core/DB/DbManager.cs
+++ b/Software/Visual_Studio/Tango.Core/DB/DbManager.cs
@@ -12,6 +12,7 @@ namespace Tango.Core.DB
     {
         private static Random random = new Random();
         private SqlConnection _connection;
+        private const int COMMAND_TIMEOUT_SECONDS = 120;
 
         #region Constructors
 
@@ -135,10 +136,12 @@ namespace Tango.Core.DB
         {
             String command = String.Format("BACKUP DATABASE {0} TO DISK = '{1}' WITH INIT", sourceDb, backupPath);
             SqlCommand cmd = new SqlCommand(command, _connection);
+            cmd.CommandTimeout = COMMAND_TIMEOUT_SECONDS;
             cmd.ExecuteNonQuery();
 
             command = String.Format("RESTORE FILELISTONLY FROM DISK='{0}'", backupPath);
             cmd = new SqlCommand(command, _connection);
+            cmd.CommandTimeout = COMMAND_TIMEOUT_SECONDS;
 
             List<String> logical_names = new List<string>();
 
@@ -152,6 +155,7 @@ namespace Tango.Core.DB
 
             command = String.Format("RESTORE DATABASE {0} FROM DISK='{1}' WITH MOVE '{2}' TO '{3}', MOVE '{4}' TO '{5}'", targetDb, backupPath, logical_names[0], targetMdf, logical_names[1], targetLdf);
             cmd = new SqlCommand(command, _connection);
+            cmd.CommandTimeout = COMMAND_TIMEOUT_SECONDS;
             cmd.ExecuteNonQuery();
 
             File.Delete(backupPath);
@@ -161,6 +165,7 @@ namespace Tango.Core.DB
         {
             String command = $"BACKUP DATABASE {name} TO DISK = '{file}'";
             SqlCommand cmd = new SqlCommand(command, _connection);
+            cmd.CommandTimeout = COMMAND_TIMEOUT_SECONDS;
             cmd.ExecuteNonQuery();
         }
 
@@ -170,6 +175,7 @@ namespace Tango.Core.DB
 
             String command = $"RESTORE DATABASE {name} FROM DISK = '{file}'";
             SqlCommand cmd = new SqlCommand(command, _connection);
+            cmd.CommandTimeout = COMMAND_TIMEOUT_SECONDS;
             cmd.ExecuteNonQuery();
 
             SetOnline(name);
@@ -179,6 +185,7 @@ namespace Tango.Core.DB
         {
             String command = $"RESTORE DATABASE {name} FROM DISK='{file}' WITH MOVE '{name}' TO '{Path.Combine(dbFolder, name)}.mdf', MOVE '{name}_log' TO '{Path.Combine(dbFolder, name)}.ldf'";
             SqlCommand cmd = new SqlCommand(command, _connection);
+            cmd.CommandTimeout = COMMAND_TIMEOUT_SECONDS;
             cmd.ExecuteNonQuery();
         }