public void DeleteSimple() { var subq = Builders <MyModel> .Select(x => x.Name) .Where(x => x.Id == 1) .AsSubquery(); var q = Builders <MyModel> .Delete() .Where(x => x.Name.PgIn(subq)); Utils.AssertRawQuery(q, @"DELETE FROM model WHERE (""name"") IN (SELECT ""name"" FROM model WHERE (""id"") = (1))"); }
public void DeleteWhere() { var q = Builders <MyModel> .Delete().Where(x => x.Id == 2); Utils.AssertRawQuery(q, @"DELETE FROM model WHERE (""id"") = (2)"); }
public void DeleteSimple() { var q = Builders <MyModel> .Delete(); Utils.AssertRawQuery(q, @"DELETE FROM model"); }