Ejemplo n.º 1
0
        public void _08_DeleteExistsXmlTest()
        {
            DBQuery q = DBQuery.DeleteFrom("Customers")
                        .WhereField("customer_id", Compare.In, DBValueGroup.All(1, 2, 3, 4, 5, 6))
                        .OrWhereField("picture", Compare.Is, DBConst.Null());

            q = SerializeAndDeserialzeQueryToMatch(q, "Exists with Or Delete");
        }
Ejemplo n.º 2
0
        public void _09_DeleteParameterXmlTest()
        {
            DBParam p1 = DBParam.ParamWithValue("first", 1);
            DBParam p2 = DBParam.ParamWithValue("second", 2);
            DBParam p3 = DBParam.ParamWithValue("third", 3);

            DBQuery q = DBQuery.DeleteFrom("Customers")
                        .WhereField("customer_id", Compare.In, DBValueGroup.All(p1, p2, p3))
                        .OrWhereField("picture", Compare.Is, DBConst.Null());

            q = SerializeAndDeserialzeQueryToMatch(q, "Parameterized Delete");
        }