public void QueryNullWhenDifferent()
{
var qry1 = new NullWhenQuery();
qry1.OptionalId = 332; // not [NullWhen(-1)], so it should be included
var sql = qry1.ResolveSql();
Assert.IsTrue(sql.Equals("SELECT [Id] FROM [Whatever] WHERE [OptionalId] = @value ORDER BY [BlahBlahBlah]"));
}
public void QueryNullWhenSame()
{
var qry1 = new NullWhenQuery();
// using -1 for this property should be the same as null because [NullWhen(-1)]
qry1.OptionalId = -1;
// don't set the OptionalId property
var qry2 = new NullWhenQuery();
// two queries should be the same
Assert.IsTrue(qry1.ResolveSql().Equals(qry2.ResolveSql()));
}
