public void update_with_schema()
{
var op = new SqlUpdateOperation { SchemaName = "dbo", TableName = "Foo" };
op.Columns.Add("var");
op.Columns.Add("var2");
Assert.AreEqual("UPDATE [dbo].[Foo] SET [var]=@var,[var2]=@var2", op.ToString());
}
public void update_with_where_clause()
{
var op = new SqlUpdateOperation { SchemaName = "dbo", TableName = "Foo" };
op.Columns.Add("var");
op.Columns.Add("var2");
op.Where("bar", "baz");
Assert.AreEqual("UPDATE [dbo].[Foo] SET [var]=@var,[var2]=@var2 WHERE [bar]=@bar", op.ToString());
}