public void TestUpdateItem() { using (SQLServerClientService sqlBase = SQLServerClientService.GetInstance(conn1)) { FilterCondition filter = new FilterCondition("id", TableCompareType.EQ, ID1); Data result = new Data() { ID = ID1, Name = "UpdatedName", Aliase = "UpdatedAliase", }; if (!sqlBase.UpdateItem(tableName, filter, result, new string[] { "Name", "Aliase" })) { Assert.Fail("UpdateItem Failed"); } sqlBase.Commit(); var obj = sqlBase.GetItem <Data>(tableName, filter); Assert.AreEqual(result.ID, obj.ID); Assert.AreEqual(result.Name, obj.Name); Assert.AreEqual(result.Aliase, obj.Aliase); sqlBase.Commit(); } }
public void TestGetItem() { using (SQLServerClientService sqlBase = SQLServerClientService.GetInstance(conn1)) { FilterCondition filter = new FilterCondition("id", TableCompareType.EQ, ID1); Data result = new Data() { ID = ID1, Name = "Name1", Aliase = null }; Data obj = sqlBase.GetItem <Data>(tableName, filter); Assert.AreEqual(result.ID, obj.ID); Assert.AreEqual(result.Name, obj.Name); Assert.AreEqual(result.Aliase, obj.Aliase); } }