Class AdbMySqlConnectorProvider

A static class which retrieves AdbProvider singleton instances that wrap the MySqlConnector ADO.NET database provider for MySQL™ and MariaDB™ databases, which assists with writing provider-independent code, mapping between .NET CLR types and database types, etc.

Use the Get() overloads to get a singleton instance with which to instantiate AdbConnectionString, AdbConnectionBuilder, AdbKeepOpenConnectionBuilder and and AdbCommandBuilder types, or pass the provider instance to other methods for them to use it.

Note that it is best practice to select which provider to use in only one place in the application, to make it easy to switch to a different provider instance, especially since settings such as how to quote identifiers is specified by picking or creating the appropriate provider instance.

Each AdbProvider instance contains a set of services that implements the provider functionality. It is possible to tweak an existing provider by using its With*() methods to create a new provider instance with one or more services replaced. Custom services can be derived from existing ones, or created from scratch. Alternatively, create a custom provider by using the AdbProvider constructor, specifying all the services.

This provider uses the following service classes:

Inheritance
Object
AdbMySqlConnectorProvider
Namespace: actionETL.Adb.MySqlConnectorExternal
Assembly: actionETL.dll
Syntax
public static class AdbMySqlConnectorProvider

Methods

Get()

Gets the MySqlConnector AdbProvider singleton instance for MySQL™ and MariaDB™ databases, with default backtick quote character, i.e. with IdentifierQuotePrefix and IdentifierQuoteSuffix set to `.

Any AdbInsertTarget<TInputError> will have DefaultValuesPerTransaction equal to 256 and MaxValuesPerBatch equal to 2000.

Also see Server SQL Modes, Schema Object Names, and Get(Boolean).

Declaration
public static AdbProvider Get()
Returns
Type Description
AdbProvider

Get(Boolean)

Gets the specified MySqlConnector AdbProvider singleton instance for MySQL™ and MariaDB™ databases.

Any AdbInsertTarget<TInputError> will have DefaultValuesPerTransaction equal to 256 and MaxValuesPerBatch equal to 2000.

Also see Server SQL Modes, Schema Object Names, and Get().

Declaration
public static AdbProvider Get(bool ansiQuotes)
Parameters
Type Name Description
Boolean ansiQuotes

Set to false to quote and parse identifiers with the default backtick, i.e. with IdentifierQuotePrefix and IdentifierQuoteSuffix set to `.

Set to true to use ANSI double quotes (") to quote and parse identifiers, i.e. with IdentifierQuotePrefix and IdentifierQuoteSuffix set to ".

Also see Server SQL Modes, Get() and Schema Object Names.

Returns
Type Description
AdbProvider

The specified AdbProvider singleton instance.

See Also