• Home
• Hd
• QueryExtensions
• SqlExpression

C# Class Hd.QueryExtensions.SqlExpression

ファイルを表示 Open project: TargetProcess/Tp.HelpDesk Class Usage Examples

Public Methods

Method	Description
Constant ( SqlConstant val ) : SqlExpression	Creates a SqlExpression which represents a constant typed value.
Constant ( SqlDataType dataType, object val ) : SqlExpression	Creates a SqlExpression which represents a constant typed value
Date ( System.DateTime val ) : SqlExpression	Creates a SqlExpression which represents a date value.
Field ( Enum fieldName ) : SqlExpression
Field ( Enum firstPart, Enum secondPart, FromTerm table ) : SqlExpression
Field ( Enum fieldName, FromTerm table ) : SqlExpression
Field ( string fieldName ) : SqlExpression	Creates a SqlExpression which represents a field in a database table.
Field ( string fieldName, FromTerm table ) : SqlExpression	Creates a SqlExpression which represents a field in a database table.
Function ( SqlAggregationFunction func, SqlExpression param ) : SqlExpression	Creates a SqlExpression with an aggergation function
IfNull ( SqlExpression test, SqlExpression val ) : SqlExpression	Creates a SqlExpression with IfNull function. Works as SQL Server's ISNULL() function.
LikeExpressionParameter ( ) : SqlExpression
LikeExpressionParameter ( Enum paramName ) : SqlExpression
LikeExpressionParameter ( string paramName ) : SqlExpression
Null ( ) : SqlExpression	Creates a SqlExpression representing a NULL value
Number ( double val ) : SqlExpression	Creates a SqlExpression which represents a numeric value.
Number ( int val ) : SqlExpression	Creates a SqlExpression which represents a numeric value.
Parameter ( ) : SqlExpression
Parameter ( string paramName ) : SqlExpression	Correct parameter name depends on your specifc data provider. OLEDB expects all parameters to be '?' and matches parameters to values based on their index. SQL Server Native driver matches parameters by names and expects to find "@paramName" parameter placeholder in the query.
PseudoField ( string fieldName ) : SqlExpression
Raw ( string sql ) : SqlExpression	Creates a SqlExpression with raw SQL
String ( string val ) : SqlExpression	Creates a SqlExpression which represents a textual value.
SubQuery ( SelectQuery query ) : SqlExpression	Creates a SqlExpression which represents a subquery.
SubQuery ( string queryText ) : SqlExpression	Creates a SqlExpression which represents a subquery. In many cases you can use an inner or outer JOIN instead of a subquery. If you prefer using subqueries it is recomended that you construct the subquery using another instance of SelectQuery, render it using the correct renderer and pass the resulting SQL statement to the queryText parameter.

Private Methods

Method	Description
SqlExpression ( ) : System

Method Details