API Reference > imodeljs-backend > ECSQL > ECSqlBinder

ECSqlBinder Class

Binds a value to an ECSQL parameter.

See also:

Methods

Name Description
addArrayElement(): ECSqlBinder Adds a new array element to the array parameter and returns the binder for the new array element

> This is the most low-level way to bind array parameters with most flexibility.		  
bind(val: any): void Binds the specified value to the ECSQL parameter.  
bindArray(val: any[]): void Binds an array value to the ECSQL parameter.  
bindBlob(blob: string | Uint8Array | ArrayBuffer | SharedArrayBuffer): void Binds a BLOB value to the ECSQL parameter.  
bindBoolean(val: boolean): void Binds a boolean value to the ECSQL parameter.  
bindDateTime(isoDateTimeString: string): void Binds a DateTime value to the ECSQL parameter.  
bindDouble(val: number): void Binds a double value to the ECSQL parameter.  
bindGuid(val: GuidString): void Binds an GUID value to the ECSQL parameter.  
bindId(val: Id64String): void Binds an Id value to the ECSQL parameter.  
bindInteger(val: number | string): void Binds an integer value to the ECSQL parameter.  
bindMember(memberName: string): ECSqlBinder Gets the binder for the specified member of a struct parameter

> This is the most low-level way to bind struct parameters with most flexibility.		  
bindNavigation(val: NavigationBindingValue): void Binds a navigation property value to the ECSQL parameter.  
bindNull(): void Binds null to the ECSQL parameter.  
bindPoint2d(val: XAndY): void Binds an Point2d value to the ECSQL parameter.  
bindPoint3d(val: XYAndZ): void Binds an Point3d value to the ECSQL parameter.  
bindRange3d(val: LowAndHighXYZ): void Binds a Range3d as a blob to the ECSQL parameter.  
bindString(val: string): void Binds an string to the ECSQL parameter.  
bindStruct(val: object): void Binds a struct property value to the ECSQL parameter.  

Defined in

Last Updated: 08 January, 2020