public void MakeSQLDeleteQueryTest()
{
string table = "Users";
string[] key = { "CUsers", "CBuddy" };
string[] value = { "20", "21" };
string expected = "DELETE FROM Users WHERE CUsers=20 AND CBuddy=21";
string actual;
actual = DBConnectionHelper.MakeSQLDeleteQuery(table, key, value);
Assert.AreEqual(expected, actual);
table = "Users";
key = new string[] { "CUsers" };
value = new string[] { "20" };
expected = "DELETE FROM Users WHERE CUsers=20";
actual = DBConnectionHelper.MakeSQLDeleteQuery(table, key, value);
Assert.AreEqual(expected, actual);
}