diff options
| author | Mirta <mirta@twine-s.com> | 2020-12-30 16:39:52 +0200 |
|---|---|---|
| committer | Mirta <mirta@twine-s.com> | 2020-12-30 16:39:52 +0200 |
| commit | 00a491d93733d4625ad329b2ba8237f445364b3f (patch) | |
| tree | 4b24c6fa78d7648f4bb7cefafa464bb0b063fec4 /Software/Visual_Studio/Tango.Core/DB | |
| parent | 124ad4150f80c6846fdee41dbbda9848c105f6e5 (diff) | |
| download | Tango-00a491d9.tar.gz Tango-00a491d9.zip | |
merge
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 |
