#FusionConnection
##Properties
| Datatype | Property name | Property description | Default Value |
|---|---|---|---|
| String | Alias | Gets the Izenda.Fusion.FusionConnection's alias that was registered with the Izenda.Fusion.FusionConnection. | inherited from concrete class |
| Boolean | IsDefault | Gets a System.Boolean representing whether this connection is the Izenda.Fusion.FusionDriver's default connection. | inherited from concrete class |
##Methods
###AliasPresents(System.String) Determines whether the input string contains the alias that was registered to this Izenda.Fusion.FusionConnection.
Parameters:
- System.String s - The database identifier to determine whether it has been aliased or not.
Returns:
A System.Boolean value representing whether the input identifier has been aliased or not.
###AppendAlias(System.String) Adds the alias and separator character for this connection to the identifier supplied.
Parameters:
- System.String s - The database identifier that should be aliased.
Returns:
The System.String representation of the entire aliased database identifier.
###Equals(System.Object) Determines whether the specified System.Object is equal to the current System.Object.
Parameters:
- System.Object obj - The System.Object to compare with the current System.Object.
Returns:
true if the specified System.Object is equal to the current System.Object; otherwise, false.
###GenerateCommand(Izenda.AdHoc.Report,System.Boolean,out System.String) Gets a SQL or XML statement that generates subtotals for the specified report with data from an OData source with the option of including filter parameters in the output. This method behaves differently for indirect and direct connections.
Parameters:
- Izenda.AdHoc.Report report - The Izenda.AdHoc.Report to generate the SQL for.
- System.Boolean grandTotalCommand - Makes the database command a grand total command or not.
- out System.String error - The output System.String representation of an error message that was generated if any errors occurred while processing the request.
###GenerateSql(Izenda.AdHoc.Report,System.Boolean,System.String,out System.Collections.IList,out System.String) Gets a SQL or XML statement for the specified report with data from an OData source with the option of including filter parameters in the output. This method behaves differently for indirect and direct connections.
Parameters:
- Izenda.AdHoc.Report report - The Izenda.AdHoc.Report to generate the SQL for.
- System.Boolean includeParams - Specifies whether to include filter parameters as output. When false, filter parameters will be added to the SQL string.
- System.String sql - The output System.String representation of the SQL command to get the report data.
- out System.Collections.IList param - The output System.Collections.IList of parameters that are used as filters.
- out System.String error - The output System.String representation of an error message that was generated if any errors occurred while processing the request.
###GenerateTotalsCommand(Izenda.AdHoc.Report,System.Int32,out System.String) Gets a SQL or XML statement that generates subtotals for the specified report with data from an OData source with the option of including filter parameters in the output. This method behaves differently for indirect and direct connections.
Parameters:
- Izenda.AdHoc.Report report - The Izenda.AdHoc.Report to generate the SQL for.
- System.Int32 firstIgnored - Specifies the index of the first column in the OrderBy clause that should be ignored.
- out System.String error - The output System.String representation of an error message that was generated if any errors occurred while processing the request.
###GenerateTotalsSql(Izenda.AdHoc.Report,System.Boolean,System.String,out System.Collections.IList,out System.String) Gets a SQL or XML statement that generates subtotals for the specified report with data from an OData source with the option of including filter parameters in the output. This method behaves differently for indirect and direct connections.
Parameters:
- Izenda.AdHoc.Report report - The Izenda.AdHoc.Report to generate the SQL for.
- System.Boolean includeParams - Specifies whether to include filter parameters as output. When false, filter parameters will be added to the SQL string.
- System.String sql - The output System.String representation of the SQL command to get the report data.
- out System.Collections.IList param - The output System.Collections.IList of parameters that are used as filters.
- out System.String error - The output System.String representation of an error message that was generated if any errors occurred while processing the request.
###GetAllTables() Gets a list of all tables and views on the schema registered to this connection.
Returns:
The Izenda.AdHoc.Database.Table array corresponding to the tables and views found.
###GetColumns(Izenda.AdHoc.Database.Table) Gets the complete list of columns found on the schema registered to this connection for the specified table.
Parameters:
- Izenda.AdHoc.Database.Table table - The Izenda.AdHoc.Database.Table to find columns for.
Returns:
The Izenda.AdHoc.Database.Column array corresponding to the columns found.
###GetConstraints(Izenda.AdHoc.Database.DatabaseSchema) Gets a list of constraints for the specified database schema.
Parameters:
- Izenda.AdHoc.Database.DatabaseSchema schema - The Izenda.AdHoc.Database.DatabaseSchema to get the constraints for.
Returns:
The Izenda.AdHoc.Database.Constraint array corresponding to the database constraints found.
###GetDatabase() Gets the System.String representation of the database that was registered with this Izenda.Fusion.DirectFusionConnection.
Returns:
The System.String that represents the database that was registered with this connection.
###GetDataSet(System.Data.IDbCommand,System.String,out System.String) Gets a System.Data.DataSet for the specified SQL command using the OData source registered to this connection.
Parameters:
- System.Data.IDbCommand command - The System.Data.IDbCommand object to execute on the OData source.
- System.String reportPart - The System.String designation for the portion of the report this query relates to.
- out System.String error - The output System.String representation of an error message that was generated if any errors occurred while processing the request.
Returns:
The new System.Data.DataSet with the results of the get_data_set command.
###GetDataTable(Izenda.AdHoc.Report,System.Data.IDbCommand,out System.String) Gets a System.Data.DataTable from the specified Izenda.AdHoc.Report and System.Data.IDbCommand provided using the OData source registered to this connection.
Parameters:
- Izenda.AdHoc.Report report - The Izenda.AdHoc.Report that corresponds to the OData source.
- System.Data.IDbCommand command - The System.Data.IDbCommand object to execute on the OData source. This command should conform to
- out System.String error - The output System.String representation of an error message that was generated if any errors occurred while processing the request.
Returns:
The first System.Data.DataTable found on the System.Data.DataSet returned by the get_data_set command.
###GetDirectConnection() Represents a method that can be used to get the Izenda.Fusion.FusionConnection that was registered as the default connection during initialization. This method must be overridden.
Returns:
The System.Data.IDbConnection representation of the Izenda.Fusion.DirectFusionConnection.
###GetHashCode() Serves as a hash function for a particular type.
Returns:
A hash code for the current System.Object.
###GetInstance() Gets the System.String representation of the instance of the DBMS or OData source that was registered with this Izenda.Fusion.DirectFusionConnection.
Returns:
The System.String that represents the name of the instance of the DBMS or OData source registered with this connection.
###GetMinMax(System.Collections.Generic.IDictionary>,out System.DateTime,out System.DateTime,out System.String) Gets the minimum and maximum System.DateTime values from a collection of date columns across various tables.
Parameters:
- System.Collections.Generic.IDictionary<System.String,System.Collections.Generic.IList<System.String>> dateTimeColumns - The System.Collections.IDictionary collection of table keys and column values to check.
- out System.DateTime minDate - The minimum System.DateTime that was found across all columns in the collection of tables.
- out System.DateTime maxDate - The maximum System.DateTime that was found across all columns in the collection of tables.
- out System.String error - The output System.String representation of an error message that was generated if any errors occurred while processing the request.
###GetType() Gets the System.Type of the current instance.
Returns:
The System.Type instance that represents the exact runtime type of the current instance.
###GetVersion() Represents a method that gets the version of the service-based datasource that is registered to this connection.
Returns:
The System.Version representation of the service-based datasource's version.
###InjectDataSet(System.Data.DataSet,System.Data.IDbConnection,out System.String) Represents a method that can be used to combine multiple datasets from various databases into a single database using the BatchSize class and the Izenda.Fusion.FusionDriver.DefaultConnection. This method must be overridden.
Parameters:
- System.Data.DataSet ds - The System.Data.DataSet produced by executing the command using a single database connection.
- System.Data.IDbConnection directConnection - The default database connection that was registered to the Izenda.Fusion.FusionDriver.
- out System.String schema - The output System.String name of the schema that this Izenda.Fusion.FusionConnectionbelongs to.
Returns:
The System.String representation of a temporary table name that will be used to copy the data for this connection into.
###InvalidateSchemaCache() Clears the server schema cache for this Izenda.Fusion.FusionConnection and forces an update on the clients as well.
###ProcessPostRequest(System.Net.HttpWebRequest) Represents a method that provides a way to intercept POST requests to OData services before the request is sent.
Parameters:
- System.Net.HttpWebRequest request - The System.Net.HttpWebRequest containing the POST information to be sent.
###RequestRealSql(Izenda.AdHoc.Report,System.Boolean,System.String,out System.Collections.IList,out System.String) Gets a SQL or XML statement for the specified report with data from multiple databases with the option of including filter parameters in the output. This method behaves differently for indirect and direct connections.
Parameters:
- Izenda.AdHoc.Report report - The Izenda.AdHoc.Report to generate the SQL for.
- System.Boolean includeParams - Specifies whether to include filter parameters as output. When false, filter parameters will be added to the SQL string.
- System.String sql - The output System.String representation of the SQL command to get the report data.
- out System.Collections.IList param - The output System.Collections.IList of parameters that are used as filters.
- out System.String error - The output System.String representation of an error message that was generated if any errors occurred while processing the request.
###RequestRealTotalsSql(Izenda.AdHoc.Report,System.Boolean,System.String,out System.Collections.IList,out System.String) Gets a SQL or XML statement that generates subtotals for the specified report with data from multiple databases with the option of including filter parameters in the output. This method behaves differently for indirect and direct connections.
Parameters:
- Izenda.AdHoc.Report report - The Izenda.AdHoc.Report to generate the SQL for.
- System.Boolean includeParams - Specifies whether to include filter parameters as output. When false, filter parameters will be added to the SQL string.
- System.String sql - The output System.String representation of the SQL command to get the report data.
- out System.Collections.IList param - The output System.Collections.IList of parameters that are used as filters.
- out System.String error - The output System.String representation of an error message that was generated if any errors occurred while processing the request.
###RetrieveDataSet(System.String,System.String,out System.String) Gets a System.DataSet object that contains the entire result set from the specified schema and table using the OData soure registered to this connection.
Parameters:
- System.String tableSchema - The System.String representation of the database schema registered to this Izenda.Fusion.FusionConnection
- System.String tableName - The System.String representation of the table name to get the data from.
- out System.String error - The output System.String representation of an error message that was generated if any errors occurred while processing the request.
Returns:
The System.Data.DataSet containing the entire table's data from the retrieve_data_set command.
###StripAliases(System.String) Represents a method that is used to ensure aliases are not used for operations that require unaliased names.
Parameters:
- System.String s - The name of the identifier to strip aliases from.
Returns:
The unaliased System.String representation of the identifier.
###ToString() Returns a System.String that represents the current System.Object.
Returns:
A System.String that represents the current System.Object.