DBDriverBase Methods

Checks if an fk constraint can be created between the fk side and the pk side specified.

Clones this instance and shallow clones the connection elements

Constructs a valid connection string from the ConnectionElements specified in this driver instance.

Constructs a valid connection string from the ConnectionElements specified.

Converts the passed in db type to the name of the type in the .NET provider specific enum.

Converts the passed in db type to its .NET type

Converts the db type to a string value

Creates a string representation of the element specified for SQL query purposes.

Converts the specified element to a full name to be used in a sql query. E.g. [catalog].[schema].[tablename] for sql server. It uses the WrapIdentifier method to create fragments for catalog/schema/table name (or view name). Override this method if the database doesn't support catalogs or schemas.

Converts the name specified to a DBType value.

Produces the DBCatalogRetriever instance to use for retrieving meta-data of a catalog.

Creates a new command with the query set as command text and a new connection object set as its connection. It sets the command timeout to the static command time set in the DDDriverbase class

Creates a new command with the query set as command text and the connection passed in set as its connection. It sets the command timeout to the static command time set in the DDDriverbase class

Creates a connection object using the factory and sets the connection string

Creates the connectiondata object to be used to obtain the required information for connecting to the database.

Creates a new data adapter with the connection specified and the query specified as the select query for the select command

Creates a new data adapter with the connection specified and the query specified as the select query for the select command

Creates a new data adapter with the connection specified and the query specified as the select query for the select command

Creates an instance of the given class in the given namespace, loaded from the given assembly. Bubbles all exceptions up.

Creates a new db parameter based on the passed in DBStoredProcedureParameter

Creates a new parameter with the value specified. It's a different implementation as the other overloads: this overload doesn't set the DbType nor the size explicitly. Some providers need that like Sybase.

Creates a new parameter with the values specified and adds it to the parameter collection of the command specified

Creates a new parameter with the values specified and adds it to the parameter collection of the command specified

Creates a SELECT fieldlist FROM elementname query where SELECT and FROM are placed on a new line. No CRLF is appended nor a query separator.

Creates a SELECT top 100 query for the element specified. The default implementation appends "LIMIT 100" to the result of CreateSelectAlLQuery. The LIMIT 100 is appended on a new line.

Creates a new command with the stored procedure call as the command text and a new connection object set as its connection. It sets the command timeout to the static command time set in the DDDriverbase class.

Creates a new command with the stored procedure call as the command text and the connection object passed in as its connection. It sets the command timeout to the static command time set in the DDDriverbase class.

Creates a TVF call statement to be used in a sql statement. Parameters are hard-coded with their names, and not values.

Returns true if the passed in type is a numeric type.

Returns true if the specified type requires a value specified in Insert queries. Not all RDBMS's require for each type a value. F.e. SqlServer doesn't require a value for Timestamp types, SqlServer will insert a value automatically.

Returns whether the specified dbtype supports a precision. By default false is returned.

Returns whether the specified dbtype supports a scale. By default false is returned.

Deserializes attributes of this element's base class from the reader.

Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.

Determines whether the specified object is equal to the current object.

Executes the string specified as one or more queries and returns the results in a list of sqlexecutionresults, one per query executed.

Executes the specified action with the active recovery strategy on this driver. If no recovery strategy is specified it will execute the action directly

Executes the specified func with the active recovery strategy on this driver. If no recovery strategy is specified it will execute the func directly

Fills the db type arrays for various conversions

Fills the DB type sort order list.

Fills the NET to DB type conversions list.

Fills the RDBMS functionality aspects list.

Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.

Generates a string with for each element in sourceElementsToUse a sql query of the statementtype specified, separated by the genuine separator for the database type, or an empty line if there's no separator known (e.g. MS Access).

Gets all catalog names from the database system connected through the specified connection elements set.

Gets all schema names from the catalog with the name specified in the database system connected through the specified connection elements set.

Gets all stored procedure names in the schema in the catalog specified in the database system connected through the specified connection elements set.

Gets all synonym names (with the target type, if applicable) in the schema in the catalog specified in the database system connected through the specified connection elements set.

Gets all system sequence instances for the database targeted. System sequences are sequences which are system wide, like @@IDENTITY.

Gets all table names in the schema in the catalog specified in the database system connected through the specified connection elements set.

Gets all table valued function names in the schema in the catalog specified in the database system connected through the specified connection elements set.

Gets all view names in the schema in the catalog specified in the database system connected through the specified connection elements set.

Gets a List of all DBTypeDefinition instances which are compatible with the type specific information passed in. The first DBTypeSpecification is the default type specification to user.

Gets a List of all DBTypeDefinition instances which are compatible with the type specific information passed in. The first DBTypeSpecification is the default type specification to user.

Gets the connection string to use.

Gets the currency types for this driver. Used for optimizing the SortOrder per db type.

Gets the db provider factory to use

Gets the DbProviderFactory invariant names to use for the factory. The first one which is found is used.

Gets the string value of the db type passed in, from the Enum specification used in this driver for type specification

Gets the decimal types for this driver. Used for optimizing the SortOrder per db type.

Gets the default name to use for catalogs

Gets a default empty catalog, for meta-data stores which are populated through the designer, if the database of this driver supports no catalogs

Gets a default empty schema, for meta-data stores which are populated through the designer, if the database of this driver supports no multiple schemas

Gets the default name to use for schemas.

Gets the fixed length types (with multiple bytes, like char, binary), not b/clobs, for this driver. Used for optimizing the SortOrder per db type.

Serves as the default hash function.

Gets the query separator string (including an empty line following it), to separate different queries in a batch. By default it returns: ";\r\n\r\n"

Gets the target description of the target the driver is connected to, for display in a UI

Gets the Type of the current instance.

Gets the variable length types (with multiple bytes, like varchar, varbinary), not b/clobs, for this driver. Used for optimizing the SortOrder per db type.

Handles the contained list changed.

Inits the data structures of this driver. Call before anything starts.

Logs an error in the ErrorLog structure of this object.

Logs the description as a warning.

Marks the element as changed.

Marks the element as removed, which raises the ElementRemoved event.

Creates a shallow copy of the current Object.

Retrieves the DbProviderFactory instance to use. By default it uses the DbProviderFactories.GetFactory() method using the names provided by the method GetDbProviderFactoryInvariantNames

Called when this object received an event of type ContainedElementAdded

Called when this object received an event of type ContainedElementChanged

Called when this object received an event of type ContainedElementRemoved

Called when the catalog with the name specified is about to be populated by this driver.

Raises the PropertyChanged event.

Performs the additional contained element changed work. Override if additional work has to be done after the OnContainedElementChanged method has run.

Performs the post set connection elements work. By default that's nothing. Use this method to process settings set in the connection dialog.

Populates the catalog(s) with the elements specified in the selectedElements datastructure. This routine uses the callbacks specified in callbacks to visualize the progress.

Pre-processes the passed in string to make it a valid custom property value. By default, strings are capped on 256 characters and CRLF's are removed.

Produces the full name for command execution. The name returned is immediately usable as a name to target the element, e.g. a stored procedure.

Produces the major and minor server version number from the ServerVersion string

Resets this instance.

Resets the Error Log for this object to an empty list.

Serializes the additional attributes.

Sets the catalog name passed in as the default catalog.

Sets the connection elements to the contents of the passed in dictionary by copying them over into the ConnectionElements dictionary. The current values in ConnectionElements are removed first.

Sets the transient error recovery strategy to the one specified.

Splits the string specified on the default separator string for this database. Assumes the string has been stripped from comments.

Splits the string specified based on lines with the delimiter string specified, e.g. 'go' on a separate line will split the string on that line, ignoring 'go'.

Suffixes the specified query with a string (usually ';') to make it usable in a single cmd execution. Some databases can't deal with a ';' at the end, so override this method in that case and suffx the fragment with another character or none at all.

Returns a string that represents the current object.

Resets the SortOrderPerDBType data-structure and updates the order with the setting values specified.

Wraps the string specified as an identifier in the characters required for the database. E.g. in postgresql / oracle the identifier is wrapped in "", in SQL Server, it's in []. The default implementation wraps it in ""