Exemple #1
0
        public void TestUpdateItemDict()
        {
            using (SQLServerClientService sqlBase = SQLServerClientService.GetInstance(conn1))
            {
                FilterCondition filter = new FilterCondition("id", TableCompareType.EQ, ID1);
                var             result = new Dictionary <string, object>()
                {
                    { "ID", ID1 },
                    { "Name", "UpdatedName" },
                    { "Age", 1 },
                    { "Aliase", "UpdatedAliase" }
                };

                if (!sqlBase.UpdateItemDict(tableName, filter, result, new string[] { "Name", "Aliase" }))
                {
                    Assert.Fail("UpdateItemDict Failed");
                }

                var obj = sqlBase.GetItemDict(tableName, filter);

                Assert.AreEqual(result["ID"], obj["ID"]);
                Assert.AreEqual(result["Name"], obj["Name"]);
                Assert.AreEqual(result["Aliase"], obj["Aliase"]);

                sqlBase.Commit();
            }
        }