#SqlDataExtractor
##Properties
None.
##Methods
###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.
###GetColumns(System.Collections.Generic.Dictionary,Izenda.Fusion.ExtractedTable) Gets the columns for the specified Izenda.Fusion.ExtractedTable by referencing the collection of Izenda.Fusion.TableItem objects provided.
Parameters:
- System.Collections.Generic.Dictionary<System.String,Izenda.Fusion.TableItem> allTablesWithColumnsByName
- Izenda.Fusion.ExtractedTable table - The Izenda.Fusion.ExtractedTable representation of the table to search for.
Returns:
The Izenda.Fusion.ExtractedColumn list that was found for the specified table.
###GetConstraints() Gets a collection of Izenda.Fusion.ExtractedConstraint objects for the MSSQL database being connected to.
Returns:
The Izenda.Fusion.ExtractedConstraint list corresponding to the database constraints found.
###GetDatabase() Gets the System.String representation of the database that was registered with this Izenda.Fusion.SqlDataExtractor.
Returns:
The System.String that represents the database that was registered with this connection.
###GetDirectConnection() Represents the System.Data.IDbConnection that is used to connect directly to the database to extract data from.
Returns:
The System.Data.IDbConnection that is current for accessing the database.
###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.SqlDataExtractor.
Returns:
The System.String that represents the name of the instance of the DBMS registered with this extractor.
###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.
Returns:
A System.Boolean indicating whether the operation was successful or not.
###GetSchema() Gets a collection of Izenda.Fusion.ExtractedTable objects that contain the extracted schema information from the MSSQL database.
Returns:
A collection of Izenda.Fusion.ExtractedTable objects containing the schema information.
###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 System.String that returns the version of the Oracle database being connected to.
Returns:
The System.String representation of the database version.
###InjectDataSet(System.Data.DataSet,System.Data.IDbConnection,out System.String) Represents a method that can be used to combine multiple datasets into a single database using the System.Data.SqlClient.SqlConnection specified.
Parameters:
- System.Data.DataSet ds - The System.Data.DataSet that should be injected into the receiving database.
- System.Data.IDbConnection directConnection - The default database connection that was registered to the Izenda.Fusion.SqlFusionDriver.
- out System.String schema - The output System.String name of the schema that this Izenda.Fusion.SqlFusionDriverconnects to.
Returns:
The System.String representation of a temporary table name that will be used to copy the data for this connection into.
###RetrieveDataSet(System.String,System.String,out System.Data.DataSet,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 the Izenda.Fusion.SqlFusionDriver registered to this extractor.
- System.String tableName - The System.String representation of the table name to get the data from.
- out System.Data.DataSet dataSet - The output System.Data.DataSet containing the entire table's data.
- 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:
A System.Boolean value indicating whether the operation was successful or not.
###SetVisibleTables(System.String[]) Sets the list of tables that this Izenda.Fusion.DataExtractor has access to when obtaining the schema and data from the registered connection.
Parameters:
- System.String[] visibleTablesList - The System.String array that represents the list of tables and views that should be included in the resulting schema.
###TestConnection() Gets a value indicating whether connectivity to the database can be established.
Returns:
A System.String status code for whether the connection was successful or had problems.
###ToString() Returns a System.String that represents the current System.Object.
Returns:
A System.String that represents the current System.Object.