public void NullHandling()
{
/// Nulls should be stripped
var testQ = new SqlQueryDef("someField=@val", new object[] { null });
Assert.AreEqual("someField=@val", testQ.GetQuery());
Assert.AreEqual(1, testQ.Parameters.Count());
testQ = new SqlQueryDef("someField=@p1 and someField2=@p2", new object[] { null, DBNull.Value });
Assert.AreEqual("someField=@p1 and someField2=@p2", testQ.GetQuery());
Assert.AreEqual(testQ.Parameters.Count(), 2);
Assert.AreEqual(DBNull.Value, testQ.Parameters.ElementAt(0).Value);
Assert.AreEqual(DBNull.Value, testQ.Parameters.ElementAt(1).Value);
}
public void Basic()
{
var testQ = new SqlQueryDef("someField=@val", new object[] { 123 });
Assert.AreEqual("someField=@val", testQ.GetQuery());
Assert.AreEqual("@val", testQ.Parameters.First().ParameterName, "Parm name was correct when created for a simple field compariosn");
Assert.AreEqual(123, testQ.Parameters.First().Value, "Parm value correct");
testQ = new SqlQueryDef("someField=@valParm", new object[] { "abc" });
Assert.AreEqual("someField=@valParm", testQ.GetQuery());
Assert.AreEqual("@valParm", testQ.Parameters.First().ParameterName, "Parm name was correct when created for a simple field compariosn");
Assert.AreEqual("abc", testQ.Parameters.First().Value, "Parm value correct");
string query = "someField=@val1 and someOtherField=@val2";
testQ = new SqlQueryDef(query, new object[] { "@val2", "abc", "@val1", 678 });
Assert.AreEqual(testQ.GetQuery(), query);
Assert.AreEqual(testQ.Parameters.ElementAt(1).ParameterName, "@val1", "Parm name was correct when created for a simple field compariosn");
Assert.AreEqual(testQ.Parameters.ElementAt(1).Value, 678, "Parm value correct");
}