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