public void Update_SingleRow_MappedExpando()
{
// Apply some quick crazy-ass mapping... to an ExpandoObject :-)
// Remember, we're mapping from crazy fake 'class' names to the sensible underlying column names
var categories = new MightyOrm(
string.Format(TestConstants.WriteTestConnection, ProviderName),
"MassiveWriteTests.Categories",
primaryKeys: "MYCATEGORYID",
columns: "MYCATEGORYID, TheName, ItsADescription",
mapper: new SqlNamingMapper(columnNameMapping: (t, c) => c
// 'class' names should come first
.Map("MYCATEGORYID", "CategoryID")
.Map("TheName", "CategoryName")
.Map("ItsADescription", "Description")));
// insert something to update first.
var inserted = categories.Insert(new { TheName = "Cool stuff", ItsADescription = "You know... cool stuff! Cool. n. stuff." });
int insertedCategoryID = inserted.MYCATEGORYID;
Assert.IsTrue(insertedCategoryID > 0);
// update it, with a better description
inserted.ItsADescription = "This is all jolly marvellous";
Assert.AreEqual(1, categories.Update(inserted), "Update should have affected 1 row");
var updatedRow = categories.Single(new { inserted.MYCATEGORYID });
Assert.IsNotNull(updatedRow);
Assert.AreEqual(inserted.MYCATEGORYID, Convert.ToInt32(updatedRow.MYCATEGORYID)); // convert from uint
Assert.AreEqual(inserted.ItsADescription, updatedRow.ItsADescription);
// reset description to NULL
updatedRow.ItsADescription = null;
Assert.AreEqual(1, categories.Update(updatedRow), "Update should have affected 1 row");
var newUpdatedRow = categories.Single(new { updatedRow.MYCATEGORYID });
Assert.IsNotNull(newUpdatedRow);
Assert.AreEqual(updatedRow.MYCATEGORYID, newUpdatedRow.MYCATEGORYID);
Assert.AreEqual(updatedRow.ItsADescription, newUpdatedRow.ItsADescription);
}