aboutsummaryrefslogtreecommitdiffstats
path: root/Software/Visual_Studio/Tango.Core/DB
diff options
context:
space:
mode:
authorRoy Ben-Shabat <Roy@Twine-s.com>2019-07-24 14:55:44 +0300
committerRoy Ben-Shabat <Roy@Twine-s.com>2019-07-24 14:55:44 +0300
commitd052a52d3a6fb6c82a4f1299a0b99dd75726edba (patch)
treebba891a86cac5dde003cedb8f7579208cb543644 /Software/Visual_Studio/Tango.Core/DB
parent13cea5de4abfa38528ba74d9542734e133acaa81 (diff)
downloadTango-d052a52d3a6fb6c82a4f1299a0b99dd75726edba.tar.gz
Tango-d052a52d3a6fb6c82a4f1299a0b99dd75726edba.zip
Working on factory reset.
Diffstat (limited to 'Software/Visual_Studio/Tango.Core/DB')
-rw-r--r--Software/Visual_Studio/Tango.Core/DB/DbManager.cs6
1 files changed, 3 insertions, 3 deletions
diff --git a/Software/Visual_Studio/Tango.Core/DB/DbManager.cs b/Software/Visual_Studio/Tango.Core/DB/DbManager.cs
index 9350f426a..10a4e26db 100644
--- a/Software/Visual_Studio/Tango.Core/DB/DbManager.cs
+++ b/Software/Visual_Studio/Tango.Core/DB/DbManager.cs
@@ -149,13 +149,13 @@ namespace Tango.Core.DB
throw new InvalidOperationException("Clear db can only be used when 'initial catalog' is specified at the connection string.");
}
- SqlCommand cmd = new SqlCommand("EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'", _connection);
+ SqlCommand cmd = new SqlCommand("EXEC sys.sp_msforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'", _connection);
cmd.ExecuteNonQuery();
- cmd = new SqlCommand("EXEC sp_MSForEachTable 'SET QUOTED_IDENTIFIER ON; DELETE FROM ?'", _connection);
+ cmd = new SqlCommand("EXEC sys.sp_msforeachtable 'DELETE FROM ?'", _connection);
cmd.ExecuteNonQuery();
- cmd = new SqlCommand("EXEC sp_MSForEachTable 'ALTER TABLE ? WITH CHECK CHECK CONSTRAINT ALL'", _connection);
+ cmd = new SqlCommand("EXEC sys.sp_MSForEachTable 'ALTER TABLE ? CHECK CONSTRAINT ALL'", _connection);
cmd.ExecuteNonQuery();
}