public void Clone()
{
var item = new WhereItem("field1", "a string");
var clone = item.Clone();
Assert.AreEqual(item, clone);
clone.Value = "something-else";
Assert.AreNotEqual(item, clone);
clone.Value = "a string";
Assert.AreEqual(item, clone);
var parm = new QueryParameter("someparm", "testvalue");
var item2 = new WhereString("field2=@someparm or field3='value'", parm);
var clause = new WhereClause(JoinType.And,item, item2);
var clone2 = clause.Clone();
Assert.AreEqual(clause, clone2);
parm.Value = "testvalue2";
Assert.AreNotEqual(clause, clone2);
parm.Value = "testvalue";
Assert.AreEqual(clause, clone2);
item.Value = "n";
Assert.AreNotEqual(clause, clone2);
item.Value = "a string";
Assert.AreEqual(clause, clone2);
}
public IWhereClause Add(string field, object value, ComparisonType comparisonType, JoinType joinType, bool parameterize = true)
{
IWhereItem crit;
crit = new WhereItem(field, value, comparisonType);
MergeWhere(crit, joinType);
return(this);
}
public void IsEmpty()
{
var item = new WhereItem();
Assert.IsTrue(item.IsEmpty);
item.Field = "test";
Assert.IsFalse(item.IsEmpty);
}
public void Create()
{
var item = new WhereItem("field1",123);
Assert.AreEqual("field1=@field1", item.GetSql());
Assert.AreEqual(1,item.Parameters.Count());
item = new WhereItem("field1", "a string",ComparisonType.LikeEndsWith,false);
Assert.AreEqual("field1 LIKE '%a string'", item.ToString());
}
public virtual IWhereItem Clone()
{
WhereItem clone = new WhereItem();
clone.Field = Field;
clone.Value = Value;
clone.Parameterize = Parameterize;
clone.ComparisonType = ComparisonType;
return(clone);
}
public void Clone()
{
var item = new WhereItem("field1","a string");
var clone = item.Clone();
Assert.AreEqual(item,clone);
clone.Value="something-else";
Assert.AreNotEqual(item,clone);
clone.Value = "a string";
Assert.AreEqual(item,clone);
}
public void Create()
{
var item1 = new WhereItem("field1",123);
var parm = new QueryParameter("someparm","testvalue");
var item2 = new WhereString("field2=@someparm",parm);
var clause = new WhereClause(JoinType.And, item1, item2);
Assert.AreEqual("field1=@field1 AND (field2=@someparm)", clause.GetSql());
Assert.AreEqual(2, clause.Parameters.Count());
}
public void Combine()
{
var item1 = new WhereItem("field1", 123);
var parm = new QueryParameter("someparm", "testvalue");
var item2 = new WhereString("field2=@someparm or field3='value'", parm);
var item3 = new WhereItem("field4", 123,parameterize:false);
var clause = new WhereClause(JoinType.And, item1, item2);
Assert.AreEqual("field1=@field1 AND (field2=@someparm or field3='value')", clause.GetSql());
var newClause = clause.Clone();
newClause.Add(item3,JoinType.Or);
Assert.AreEqual("(field1=@field1 AND (field2=@someparm or field3='value')) OR field4=123", newClause.GetSql());
Assert.AreEqual(2, newClause.Parameters.Count());
}
public IWhereClause Add(string field, object value, ComparisonType comparisonType, JoinType joinType, bool parameterize = true)
{
IWhereItem crit;
crit = new WhereItem(field, value, comparisonType);
MergeWhere(crit, joinType);
return this;
}
public virtual IWhereItem Clone()
{
WhereItem clone = new WhereItem();
clone.Field = Field;
clone.Value = Value;
clone.Parameterize = Parameterize;
clone.ComparisonType = ComparisonType;
return clone;
}
