Baruah.DataSmith.Database.QueryBuilder< T > Class Template Reference

Inheritance diagram for Baruah.DataSmith.Database.QueryBuilder< T >:

Public Member Functions
	QueryBuilder ()
QueryBuilder< T >	Where (string condition)
	Where Condition.
QueryBuilder< T >	OrderBy (string clause)
	Set the order of response.
QueryBuilder< T >	Limit (int count)
	set limit
string	BuildSelect (string columns="*")
	Build select.
string	BuildAggregate (string function)
	Build Aggregate.
int	Count (string columns="*")
int	Sum (string columns="*")
float	Average (string columns="*")
int	Max (string columns="*")
int	Min (string columns="*")
T	FirstOrDefault ()

Protected Member Functions
TResult	ExecuteScalar< TResult > (string sqlFunction)
string	BuildWhereClause ()

Protected Attributes
readonly List< string >	_where = new()
readonly List< string >	_orderBy = new()
readonly List< string >	_conditions = new()

Member Function Documentation

Average()

float Baruah.DataSmith.Database.QueryBuilder< T >.Average

(

string

columns = "*"

)

BuildAggregate()

string Baruah.DataSmith.Database.QueryBuilder< T >.BuildAggregate

(

string

function

)

Build Aggregate.

Parameters

function

function

Returns

sql query

BuildSelect()

string Baruah.DataSmith.Database.QueryBuilder< T >.BuildSelect

(

string

columns = "*"

)

Build select.

Parameters

columns

columns

Returns

sql query

BuildWhereClause()

string Baruah.DataSmith.Database.QueryBuilder< T >.BuildWhereClause ( )

protected

Count()

int Baruah.DataSmith.Database.QueryBuilder< T >.Count

(

string

columns = "*"

)

ExecuteScalar< TResult >()

TResult Baruah.DataSmith.Database.QueryBuilder< T >.ExecuteScalar< TResult > ( string sqlFunction )

abstractprotected

FirstOrDefault()

T Baruah.DataSmith.Database.QueryBuilder< T >.FirstOrDefault

(

)

Limit()

QueryBuilder< T > Baruah.DataSmith.Database.QueryBuilder< T >.Limit

(

int

count

)

set limit

Parameters

count

number of element count

Returns

QueryBuilder

Max()

int Baruah.DataSmith.Database.QueryBuilder< T >.Max

(

string

columns = "*"

)

Min()

int Baruah.DataSmith.Database.QueryBuilder< T >.Min

(

string

columns = "*"

)

OrderBy()

QueryBuilder< T > Baruah.DataSmith.Database.QueryBuilder< T >.OrderBy

(

string

clause

)

Set the order of response.

Parameters

clause

Returns

QueryBuilder

QueryBuilder()

Baruah.DataSmith.Database.QueryBuilder< T >.QueryBuilder

(

)

Sum()

int Baruah.DataSmith.Database.QueryBuilder< T >.Sum

(

string

columns = "*"

)

Where()

QueryBuilder< T > Baruah.DataSmith.Database.QueryBuilder< T >.Where

(

string

condition

)

Where Condition.

Parameters

condition

condition

Returns

QueryBuilder

Member Data Documentation

_conditions

readonly List<string> Baruah.DataSmith.Database.QueryBuilder< T >._conditions = new()

protected

_orderBy

readonly List<string> Baruah.DataSmith.Database.QueryBuilder< T >._orderBy = new()

protected

_where

readonly List<string> Baruah.DataSmith.Database.QueryBuilder< T >._where = new()

protected

---

The documentation for this class was generated from the following file:

• Runtime/Core/QueryBuilder.cs