public void SqlUpdateTest()
{
var update = new SqlUpdate("Table")
.Set("Column1", 1)
.Set("Column1", 2)
.Set("Column2", 3)
.Set("Column3 = Column3 + 2");
Assert.AreEqual("update Table set Column1 = ?, Column2 = ?, Column3 = Column3 + 2", update.ToString());
update = new SqlUpdate("Table")
.Set("Column1", 1)
.Set("Column1", 2)
.Set("Column3", new SqlQuery("Table2").Select("x").Where("y", 5));
Assert.AreEqual("update Table set Column1 = ?, Column3 = (select x from Table2 where y = ?)", update.ToString());
}
public void Add(SqlUpdate statement)
{
AddCommandWithParameters(statement.ToString(), statement.Params);
}
public void SqlUpdateTest()
{
var update = new SqlUpdate("Table")
.Set("Column1", 1)
.Set("Column1", 2)
.Set("Column2", 3)
.Set("Column3 = Column3 + 2");
Assert.AreEqual("update Table set Column1 = ?, Column2 = ?, Column3 = Column3 + 2", update.ToString());
}
public override string ToString()
{
return(_sqlUpdate.ToString());
}
