aboutsummaryrefslogtreecommitdiffstats
path: root/Software/Visual_Studio/Tango.Core/DB
diff options
context:
space:
mode:
authorMirta <mirta@twine-s.com>2020-12-30 16:39:52 +0200
committerMirta <mirta@twine-s.com>2020-12-30 16:39:52 +0200
commit00a491d93733d4625ad329b2ba8237f445364b3f (patch)
tree4b24c6fa78d7648f4bb7cefafa464bb0b063fec4 /Software/Visual_Studio/Tango.Core/DB
parent124ad4150f80c6846fdee41dbbda9848c105f6e5 (diff)
downloadTango-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.cs42
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