Interface ISqlValueAdapter

SQL value description adapter

Inherited Members
Namespace: XData.Database.SqlBlock
Assembly: XData.docfx.dll
Syntax
public interface ISqlValueAdapter : ISqlVarAdapter

Methods

| Improve this Doc View Source

Const<T>(T, DbType)

SQL constant value

Declaration
ISqlValue<T> Const<T>(T value, DbType dbType)
Parameters
Type Name Description
T value

Constant value
DbType dbType

Constant DbType
Returns
Type Description
ISqlValue<T>

SQL value description
Type Parameters
Name Description
T

Constant mapped type
| Improve this Doc View Source

Data<T>(String)

Data value

Declaration
ISqlValue<T> Data<T>(string name)
Parameters
Type Name Description
String name

Data column or parameter name
Returns
Type Description
ISqlValue<T>

SQL value description
Type Parameters
Name Description
T

Data type
| Improve this Doc View Source

Default<T>(DefaultType)

Default value mapping

Declaration
ISqlValue<T> Default<T>(DefaultType defaultType)
Parameters
Type Name Description
DefaultType defaultType

Default value type
Returns
Type Description
ISqlValue<T>

SQL value description
Type Parameters
Name Description
T

Value mapped type
| Improve this Doc View Source

Default<T>(DefaultType, Object)

Default value mapping

Declaration
ISqlValue<T> Default<T>(DefaultType defaultType, object defaultValue)
Parameters
Type Name Description
DefaultType defaultType

Default value type
Object defaultValue

Default value
Returns
Type Description
ISqlValue<T>

SQL value description
Type Parameters
Name Description
T

Value mapped type
| Improve this Doc View Source

Expr<T>(Expression<Func<IBlockQueryAdapter, T>>, DbType)

SQL expression mapping

Declaration
ISqlValue<T> Expr<T>(Expression<Func<IBlockQueryAdapter, T>> expr, DbType dbType)
Parameters
Type Name Description
Expression<Func<IBlockQueryAdapter, T>> expr

Expression
DbType dbType

Expression database type
Returns
Type Description
ISqlValue<T>

SQL value description
Type Parameters
Name Description
T

Value mapped type
| Improve this Doc View Source

Expr<T>(String, DbType)

SQL expression mapping

Declaration
ISqlValue<T> Expr<T>(string exprText, DbType dbType)
Parameters
Type Name Description
String exprText

Expression text
DbType dbType

Expression database type
Returns
Type Description
ISqlValue<T>

SQL value description
Type Parameters
Name Description
T

Value mapped type
| Improve this Doc View Source

Field<T>(String, String)

SQL field mapping

Declaration
ISqlValue<T> Field<T>(string alias, string fieldName)
Parameters
Type Name Description
String alias

Data source alias
String fieldName

Field name
Returns
Type Description
ISqlValue<T>

SQL value description
Type Parameters
Name Description
T

Value mapped type
| Improve this Doc View Source

Subquery<T>(Expression<Func<IBlockQueryStructure, IBlockQueryStructure>>, Expression<Func<IBlockQueryAdapter, T>>)

Single column subquery as value

Declaration
ISqlValue<T> Subquery<T>(Expression<Func<IBlockQueryStructure, IBlockQueryStructure>> query, Expression<Func<IBlockQueryAdapter, T>> field)
Parameters
Type Name Description
Expression<Func<IBlockQueryStructure, IBlockQueryStructure>> query

Query structure
Expression<Func<IBlockQueryAdapter, T>> field

Result field
Returns
Type Description
ISqlValue<T>

SQL value description
Type Parameters
Name Description
T

Value mapped type
| Improve this Doc View Source

Subquery<T>(Expression<Func<IBlockQueryStructure, IBlockQueryStructure>>, Expression<Func<IBlockQueryAdapter, T>>, DataStructureFlag)

Single column subquery as value

Declaration
ISqlValue<T> Subquery<T>(Expression<Func<IBlockQueryStructure, IBlockQueryStructure>> query, Expression<Func<IBlockQueryAdapter, T>> field, DataStructureFlag flag)
Parameters
Type Name Description
Expression<Func<IBlockQueryStructure, IBlockQueryStructure>> query

Query structure
Expression<Func<IBlockQueryAdapter, T>> field

Result field
DataStructureFlag flag

Query structure flag
Returns
Type Description
ISqlValue<T>

SQL value description
Type Parameters
Name Description
T

Value mapped type

Extension Methods