public void UpdateObject(DMSource DataObject)
{
UpdateQuery query = QueryBuilder.Update(TABLE);
((UpdateQuery)query).AddWhereFragment(DataObject.ID);
foreach (var entry in DATA_MAP.DataColumns)
{
var value = entry.Value.GetValue(DataObject);
if (value != null)
{
query.AddPropertyValue(entry.Key.ColumnName, @value.ToString().Replace("'", "''''"));
}
}
var cmd = db.GetCommand(query.Build());
cmd.ExecuteNonQuery();
}
public void TestGenerateUpdateWithID()
{
var schemeName = TestingTools.RandomString;
var tableName = TestingTools.RandomString;
var propertyName = TestingTools.RandomString;
var propertyValue = TestingTools.RandomString;
var id = TestingTools.RandomInt;
UpdateQuery query = new UpdateQuery(schemeName, tableName);
query.AddPropertyValue(propertyName, propertyValue);
query.AddWhereFragment(id);
var result = query.Build();
var expected = String.Format("UPDATE \"{0}\".\"{1}\" SET \"{2}\"='{3}' WHERE \"ID\"={4};",
schemeName, tableName, propertyName, propertyValue, id);
Assert.IsNotNull(result);
Assert.AreEqual(expected, result);
}
public void TestGenerateUpdateWithWhere()
{
var schemeName = TestingTools.RandomString;
var tableName = TestingTools.RandomString;
var propertyName = TestingTools.RandomString;
var propertyValue = TestingTools.RandomString;
var id = TestingTools.RandomInt;
UpdateQuery query = new UpdateQuery(schemeName, tableName);
query.AddPropertyValue(propertyName, propertyValue);
Expression <Func <ConnectionDM, bool> > exp = (item) => item.ChildID == id;
query.AddWhereFragment((BinaryExpression)exp.Body);
var result = query.Build();
var expected = String.Format("UPDATE \"{0}\".\"{1}\" SET \"{2}\"='{3}' WHERE \"ChildID\" = '{4}';",
schemeName, tableName, propertyName, propertyValue, id);
Assert.IsNotNull(result);
Assert.AreEqual(expected, result);
}