diff options
Diffstat (limited to 'Software/Visual_Studio/Tango.Core/DB')
| -rw-r--r-- | Software/Visual_Studio/Tango.Core/DB/DbManager.cs | 42 |
1 files changed, 1 insertions, 41 deletions
diff --git a/Software/Visual_Studio/Tango.Core/DB/DbManager.cs b/Software/Visual_Studio/Tango.Core/DB/DbManager.cs index d6eb521bd..1d415fdb1 100644 --- a/Software/Visual_Studio/Tango.Core/DB/DbManager.cs +++ b/Software/Visual_Studio/Tango.Core/DB/DbManager.cs @@ -65,28 +65,13 @@ namespace Tango.Core.DB #region Public Methods - public void Create(String name, String filePath = null) + public void Create(String name) { String command = String.Format("CREATE DATABASE {0}", name); - - if (filePath != null) - { - command = $"CREATE DATABASE {name} ON (name='{name}', filename='{filePath}')"; - } - SqlCommand cmd = new SqlCommand(command, _connection); cmd.ExecuteNonQuery(); } - public Task ExecuteCommandAsync(String command) - { - return Task.Factory.StartNew(() => - { - SqlCommand cmd = new SqlCommand(command, _connection); - cmd.ExecuteNonQuery(); - }); - } - public bool Exists(String name) { try @@ -175,13 +160,6 @@ namespace Tango.Core.DB SetOnline(name); } - public void RestoreAsNew(String name, String file, String dbFolder) - { - 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.ExecuteNonQuery(); - } - public void ClearDb() { if (!_connection.ConnectionString.ToLower().Contains("initial catalog")) @@ -287,24 +265,6 @@ EXEC sp_executesql @statement return cred; } - public String GetValue(String query, String columnName) - { - string sql = query; - var cm = new SqlCommand(sql, _connection); - var dr = cm.ExecuteReader(); - if (dr.Read()) - { - var value = dr[columnName]; - - if (value != null) - { - return value.ToString(); - } - } - - return null; - } - #endregion #region IDisposable |