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");
}
