Click or drag to resize

EAPUtilSQLString Method (Object, OleDbType, DBMSType)

Generate a SQL representation of the value for the specified DataType and DBMS.

Namespace:  NetQuarry
Assembly:  EAP.Core (in EAP.Core.dll) Version: 2.0.0.0 (4.6.8.0)
Syntax
Copy
public static string SQLString(
	Object val,
	OleDbType dataType,
	DBMSType dbmsType
)

Parameters

val
Type: SystemObject
The value to format.
dataType
Type: System.Data.OleDbOleDbType
The data type of the value.
dbmsType
Type: NetQuarryDBMSType
The DBMS for which to format.

Return Value

Type: String
The value formatted for use in a SQL statement against the specified DBMS.
Remarks
If DBMSType is zero the SQL will be rendered in a DBMS-independent manner possibly including embedded expressions.
See Also