Exago .NET API Documentation
SqlObject Class Members
Properties  Methods 

WebReports.Api.Data Namespace : SqlObject Class

The following tables list the members exposed by SqlObject.

Public Constructors
 NameDescription
Public ConstructorSqlObject ConstructorOverloaded.   
Top
Public Properties
 NameDescription
Public PropertyCanRangeSelectOverridden. Indicates is selecting a range of rows is supported by the associated Data Source.  
Public PropertyCanRowLimitOverridden. Indicates if setting a row limit is supported by the associated Data Source.  
Public PropertyDbConnectOverridden. The DbConnect object that this object uses to connect to the Data Source  
Top
Public Methods
 NameDescription
Public MethodCanAggregateInDatabaseDetermine if aggregation can occur in the Data Source for this SqlObject.  
Public MethodConstructSqlStmtConstruct a SQL statement that can be passed to a SQL Data Source based on the properties of this SqlObject.  
Public MethodExecuteOverridden. 

Executes the constructed SQL statement on the Data Source and returns a System.Data.DataSet object with the data returned from the Data Source.

Calling this method will also trigger the OnExecuteSqlStatementConstructed, OnFilterSqlStatementConstructed or OnParameterSqlStatementConstructed Server Event depending on its context.

 
Public MethodGetDropdownDataOverridden.   
Public MethodTestSqlOverridden. Makes a connection to the Data Source, executes the sqlStmt on it and attempts to retrieve the resulting schema.  
Top
See Also

Reference

SqlObject Class
WebReports.Api.Data Namespace

 

 

Version: 2021.2.6 Last published: 5/18/2022

Contact Exago Support