Conjunction

This is an enum used to define a conjunction when grouping an expression via QueryGroup object.

Enum Values

Below is the list of enum values.

Name	Description
! And	Is used to define an `AND` expression during the grouping. This is the default setting.
Or	Is used to define an `OR` expression during the grouping

Usability

Simply pass it in the constructor when instantiating a QueryGroup object.

var query = new QueryGroup
(
    new []
    {
        new QueryField("Id", Operation.GreaterThanOrEqual, 10000),
        new QueryField("CreatedDateUtc", Operation.GreaterThanOrEqual, DateTime.UtcNow.Date.AddMonths(-3))
    },
    Conjunction.And
);

The query group above would result a SQL statement below.

> WHERE ([Id] >= @Id AND [CreatedDateUtc] >= @CreatedDateUtc)

Although by default, the value is And, you can override it by passing the Or.

var query = new QueryGroup
(
    new []
    {
        new QueryField("Id", 10045),
        new QueryField("Id", 10057)
    },
    Conjunction.Or
);

Which would result a SQL statement below.

> WHERE ([Id] = @Id OR [Id] = @Id2)