internal string GetSqlStringWithNoParameters() { string strOp = _sqlOperator.ToUpper().Trim(); if (strOp == "IS" || strOp == "IS NOT" || strOp == "NOT IS") { return _parameterValue.ToUpper(); //return either NULL or NOT NULL } if (strOp == "IN" || strOp == "NOT IN") { return _parameterValue; } return ""; }
public void TestGetSqlStringWithNoParameters() { Parameter param = new Parameter("prop", "table", "field", "=", "value", ParameterType.String); Assert.AreEqual("", param.GetSqlStringWithNoParameters()); }