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