• 홈
• Hd
• QueryExtensions
• SqlExpression

C# 클래스 Hd.QueryExtensions.SqlExpression

파일 보기 프로젝트 열기: TargetProcess/Tp.HelpDesk 1 사용 예제들

공개 메소드들

메소드	설명
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.

비공개 메소드들

메소드	설명
SqlExpression ( ) : System

메소드 상세