C# Class IQMap.SqlQueryBuilder.Impl.SqlQueryMaker

Inheritance: ISqlQueryMaker

Mostrar archivo Open project: jamietre/IQMap Class Usage Examples

Protected Properties

Property	Type	Description
_From	string
_IsDirty	bool
_PrimaryKey	string
_Select	string
_TableName	string
_orderByClause	IOrderByClause
_sqlFieldMap	Lazy
_updateData	SqlValue>>.Lazy
_whereClause	IWhereClause
groupBy	string
having	string
top	int

Private Properties

Property	Type	Description
ISqlQuery	ISqlQuery

Public Methods

Method	Description
AddFieldMap ( string>.IEnumerable map ) : void	Add a range of key/value pairs to map field names to SQL server column names
AddFieldMap ( string fieldName, string value ) : void	Map a field name to an alternate representation to be passed to the SQL Server
AddParameter ( IDataParameter parameter ) : void
AddParameter ( IEnumerable parameter ) : void
AddUpdateData ( string fieldName, object value ) : ISqlQuery
Clean ( ) : void	Marks this object as unchanged (IsDirty=false)
Clear ( ) : void	Clears all criteria. This does not clear the field map.
ClearFieldMap ( ) : void	Clear all current aliases in the field map
Clone ( ) : ISqlQueryMaker
Clone ( QueryType type ) : ISqlQueryMaker
Equals ( object obj ) : bool
ExpectType ( QueryType type ) : void
GetFieldMap ( string name ) : string	Returns the mapped value for a field alias
GetHashCode ( ) : int
GetNewParameterName ( string basedOn = "" ) : string
GetQuery ( ) : string
GetQuery ( SqlClause clause ) : string	Return the SQL for this query
SqlAuditString ( ) : string
SqlQueryMaker ( ) : System
SqlQueryMaker ( QueryType queryType ) : System
ToString ( ) : string
Touch ( ) : void	Mark the object as dirty

Protected Methods

Method	Description
CloneImpl ( ) : SqlQueryMaker	Returns a deep copy of this object
Initialize ( QueryType queryType ) : void
RequireClauses ( SqlClause clause ) : void

Private Methods

Method	Description
ISqlQuery ( ) : ISqlQuery

Method Details

AddFieldMap() public method

Add a range of key/value pairs to map field names to SQL server column names

public AddFieldMap ( string>.IEnumerable map ) : void
map	string>.IEnumerable
return	void

AddFieldMap() public method

Map a field name to an alternate representation to be passed to the SQL Server

public AddFieldMap ( string fieldName, string value ) : void
fieldName	string
value	string
return	void

AddParameter() public method

public AddParameter ( IDataParameter parameter ) : void
parameter	IDataParameter
return	void

AddParameter() public method

public AddParameter ( IEnumerable parameter ) : void
parameter	IEnumerable
return	void

AddUpdateData() public method

public AddUpdateData ( string fieldName, object value ) : ISqlQuery
fieldName	string
value	object
return	ISqlQuery

Clean() public method

Marks this object as unchanged (IsDirty=false)

public Clean ( ) : void
return	void

Clear() public method

Clears all criteria. This does not clear the field map.

public Clear ( ) : void
return	void

ClearFieldMap() public method

Clear all current aliases in the field map

public ClearFieldMap ( ) : void
return	void

Clone() public method

public Clone ( ) : ISqlQueryMaker
return	ISqlQueryMaker

Clone() public method

public Clone ( QueryType type ) : ISqlQueryMaker
type	QueryType
return	ISqlQueryMaker

CloneImpl() protected method

Returns a deep copy of this object

protected CloneImpl ( ) : SqlQueryMaker
return	SqlQueryMaker

Equals() public method

public Equals ( object obj ) : bool
obj	object
return	bool

ExpectType() public method

public ExpectType ( QueryType type ) : void
type	QueryType
return	void

GetFieldMap() public method

Returns the mapped value for a field alias

public GetFieldMap ( string name ) : string
name	string
return	string

GetHashCode() public method

public GetHashCode ( ) : int
return	int

GetNewParameterName() public method

public GetNewParameterName ( string basedOn = "" ) : string
basedOn	string
return	string

GetQuery() public method

public GetQuery ( ) : string
return	string

GetQuery() public method

Return the SQL for this query

public GetQuery ( SqlClause clause ) : string
clause	SqlClause
return	string

Initialize() protected method

protected Initialize ( QueryType queryType ) : void
queryType	QueryType
return	void

RequireClauses() protected method

protected RequireClauses ( SqlClause clause ) : void
clause	SqlClause
return	void

SqlAuditString() public method

public SqlAuditString ( ) : string
return	string

SqlQueryMaker() public method

public SqlQueryMaker ( ) : System
return	System

SqlQueryMaker() public method

public SqlQueryMaker ( QueryType queryType ) : System
queryType	QueryType
return	System

ToString() public method

public ToString ( ) : string
return	string

Touch() public method

Mark the object as dirty

public Touch ( ) : void
return	void

Property Details

_From protected_oe property

protected string _From
return	string

_IsDirty protected_oe property

protected bool _IsDirty
return	bool

_PrimaryKey protected_oe property

protected string _PrimaryKey
return	string

_Select protected_oe property

protected string _Select
return	string

_TableName protected_oe property

protected string _TableName
return	string

_orderByClause protected_oe property

protected IOrderByClause _orderByClause
return	IOrderByClause

_sqlFieldMap protected_oe property

protected Lazy _sqlFieldMap
return	Lazy

_updateData protected_oe property

protected Lazy> _updateData
return	SqlValue>>.Lazy

_whereClause protected_oe property

protected IWhereClause _whereClause
return	IWhereClause

groupBy protected_oe property

protected string groupBy
return	string

having protected_oe property

protected string having
return	string

top protected_oe property

protected int top
return	int