#DirectFusionConnection
##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. | null |
| Boolean | IsDefault | Gets a System.Boolean representing whether this connection is the Izenda.Fusion.FusionDriver's default connection. | null |
##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) Creates an System.Data.IDbCommand object from the specified Izenda.AdHoc.Report with data from multiple databases.
Parameters:
- Izenda.AdHoc.Report report - The Izenda.AdHoc.Report to generate a database command for.
- System.Boolean grandTotalCommand - Makes the database command a grand total command or not.
- out System.String error
Returns:
The System.Data.IDbCommand that can be executed to get the report data.
###GenerateSql(Izenda.AdHoc.Report,System.Boolean,System.String,out System.Collections.IList,out System.String) Gets a SQL statement for the specified report with data from multiple databases with the option of including filter parameters in the output.
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 System.Data.IDbCommand that produces grand totals for the specified Izenda.AdHoc.Report with data from multiple databases.
Parameters:
- Izenda.AdHoc.Report report - The Izenda.AdHoc.Report that will be used to generate the command for.
- System.Int32 firstIgnored - Specifies the index of the first column in the OrderBy clause that should be ignored
- out System.String error
Returns:
The System.Data.IDbCommand that produces grand totals.
###GenerateTotalsSql(Izenda.AdHoc.Report,System.Boolean,System.String,out System.Collections.IList,out System.String) Gets a SQL statement that generates subtotals for the specified report with data from multiple databases with the option of including filter parameters in the output.
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.
Parameters:
- System.Data.IDbCommand command - The System.Data.IDbCommand that will be evaluated and executed.
- 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 query.
###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.
Parameters:
- Izenda.AdHoc.Report report - The Izenda.AdHoc.Report that corresponds to the database command
- System.Data.IDbCommand command - The System.Data.IDbCommand object to execute on the database.
- 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 query.
###GetDirectConnection() Gets the Izenda.Fusion.FusionConnection that was registered as the default connection during initialization.
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 that was registered with this Izenda.Fusion.DirectFusionConnection.
Returns:
The System.String that represents the name of the instance of the DBMS 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) Allows a Izenda.Fusion.FusionDriver to combine multiple datasets from various databases into a single database using the System.Data.SqlClient.SqlBulkCopy class and the DefaultConnection.
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 statement for the specified report with data from multiple databases with the option of including filter parameters in the output.
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 statement that generates subtotals for the specified report with data from multiple databases with the option of including filter parameters in the output.
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.Data.DataSet object that contains the entire result set from the specified schema and table.
Parameters:
- System.String tableSchema - The System.String representation of the database schema registered to this Izenda.Fusion.DirectFusionConnection
- 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.
###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.