Interface IWhereBuilder

Namespace

Dapper.SimpleSqlBuilder.FluentBuilder

Assembly

Dapper.SimpleSqlBuilder.dll

An interface that defines the where builder type.

public interface IWhereBuilder : IGroupByBuilder, IHavingBuilder, IOrderByBuilderEntry, IFluentSqlBuilder, ISqlBuilder, IFluentBuilder

Implements

IGroupByBuilder

IHavingBuilder

IOrderByBuilderEntry

IFluentSqlBuilder

ISqlBuilder

IFluentBuilder

Methods

OrWhere(ref WhereOrInterpolatedStringHandler)

Appends the OR clause and the interpolated string to the builder. If no WHERE clause is present, the WHERE clause is appended.

IWhereBuilder OrWhere(ref WhereOrInterpolatedStringHandler handler)

Parameters

handler WhereOrInterpolatedStringHandler

The handler for the interpolated string.

Returns

IWhereBuilder

The IWhereBuilder instance.

OrWhere(bool, ref WhereOrInterpolatedStringHandler)

Appends the OR clause and the interpolated string to the builder. If no WHERE clause is present, the WHERE clause is appended.

IWhereBuilder OrWhere(bool condition, ref WhereOrInterpolatedStringHandler handler)

Parameters

condition bool

The value to determine whether the method should be executed.

handler WhereOrInterpolatedStringHandler

The handler for the interpolated string.

Returns

IWhereBuilder

The IWhereBuilder instance.

OrWhereFilter(ref WhereOrFilterInterpolatedStringHandler)

Appends the OR clause, starts a filter group, and appends the interpolated string to the builder. If no WHERE clause is present, the WHERE clause is appended.

IWhereFilterBuilder OrWhereFilter(ref WhereOrFilterInterpolatedStringHandler handler)

Parameters

handler WhereOrFilterInterpolatedStringHandler

The handler for the interpolated string.

Returns

IWhereFilterBuilder

The IWhereFilterBuilder instance.

OrWhereFilter()

Starts an OR clause filter group. If no WHERE clause is present, the WHERE clause is appended.

IWhereFilterBuilder OrWhereFilter()

Returns

IWhereFilterBuilder

The IWhereFilterBuilder instance.

Where(ref WhereInterpolatedStringHandler)

Appends the WHERE clause and the interpolated string to the builder. If the WHERE clause is already present, the AND clause is appended.

IWhereBuilder Where(ref WhereInterpolatedStringHandler handler)

Parameters

handler WhereInterpolatedStringHandler

The handler for the interpolated string.

Returns

IWhereBuilder

The IWhereBuilder instance.

Where(bool, ref WhereInterpolatedStringHandler)

Appends the WHERE clause and the interpolated string to the builder. If the WHERE clause is already present, the AND clause is appended.

IWhereBuilder Where(bool condition, ref WhereInterpolatedStringHandler handler)

Parameters

condition bool

The value to determine whether the method should be executed.

handler WhereInterpolatedStringHandler

The handler for the interpolated string.

Returns

IWhereBuilder

The IWhereBuilder instance.

WhereFilter(ref WhereFilterInterpolatedStringHandler)

Appends the WHERE clause, starts a filter group, and appends the interpolated string to the builder. If the WHERE clause is already present, the AND clause is appended.

IWhereFilterBuilder WhereFilter(ref WhereFilterInterpolatedStringHandler handler)

Parameters

handler WhereFilterInterpolatedStringHandler

The handler for the interpolated string.

Returns

IWhereFilterBuilder

The IWhereFilterBuilder instance.

WhereFilter()

Starts a WHERE clause filter group. If the WHERE clause is already present, the AND clause is appended.

IWhereFilterBuilder WhereFilter()

Returns

IWhereFilterBuilder

The IWhereFilterBuilder instance.