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