public void SqlServerUpdateCommandWithKeyColumns() { var upd = new SqlServerCmd("dbo.Table1", "Id") { { "FirstName", "Adam" }, { "LastName", "O'Neil" } }; var cmd = upd.GetUpdateStatement(); Assert.IsTrue(cmd.ReplaceWhitespace().Equals( @"UPDATE [dbo].[Table1] SET [FirstName]=@FirstName, [LastName]=@LastName WHERE [Id]=@Id".ReplaceWhitespace())); }
public void SqlServerUpdateWithExpression() { var upd = new SqlServerCmd("dbo.Table1", "Id") { { "FirstName", "Adam" }, { "LastName", "O'Neil" }, { "Weight", new SqlExpression("[Weight]-10") } // lost 10 lbs, yay!!! }; var cmd = upd.GetUpdateStatement(); Assert.IsTrue(cmd.ReplaceWhitespace().Equals( @"UPDATE [dbo].[Table1] SET [FirstName]=@FirstName, [LastName]=@LastName, [Weight]=[Weight]-10 WHERE [Id]=@Id".ReplaceWhitespace())); }