public void CmdDictionaryInsert()
{
using (var cn = GetConnection())
{
var cmd = SqlServerCmd.FromTableSchemaAsync(cn, "dbo", "Employee").Result;
cmd["FirstName"] = "Wilbur";
cmd["LastName"] = "Wainright";
cmd["IsExempt"] = true;
cmd["Timestamp"] = new SqlExpression("getdate()");
cmd["Status"] = Status.Active;
var sql = cmd.GetInsertStatement();
var id = cmd.InsertAsync <int>(cn).Result;
Assert.IsTrue(cn.RowExistsAsync("[dbo].[Employee] WHERE [LastName]='Wainright'").Result);
}
}
public void CmdDictionaryUpdate()
{
// create our sample row
CmdDictionaryInsert();
using (var cn = GetConnection())
{
var cmd = SqlServerCmd.FromTableSchemaAsync(cn, "dbo", "Employee").Result;
cmd["FirstName"] = "Wilbur";
cmd["LastName"] = "Wainright2";
cmd["IsExempt"] = true;
cmd["Timestamp"] = new SqlExpression("getdate()");
cmd["Status"] = Status.Inactive;
cmd["Value"] = OtherEnum.That;
cmd.UpdateAsync(cn, 1).Wait();
Assert.IsTrue(cn.RowExistsAsync("[dbo].[Employee] WHERE [LastName]='Wainright2'").Result);
}
}
