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"); }
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"); }