MySqlLinkedService Class

Initializes a new instance of MySqlLinkedService.

Additional Properties

To assign an object to the value of this property use FromObjectAsJson<T>(T, JsonSerializerOptions).

To assign an already formatted json string to this property use FromString(String).

Examples:

• BinaryData.FromObjectAsJson("foo"): Creates a payload of "foo".
• BinaryData.FromString("\"foo\""): Creates a payload of "foo".
• BinaryData.FromObjectAsJson(new { key = "value" }): Creates a payload of { "key": "value" }.
• BinaryData.FromString("{\"key\": \"value\"}"): Creates a payload of { "key": "value" }.

This allows the special “zero” date value 0000-00-00 to be retrieved from the database. Type: boolean.

List of tags that can be used for describing the linked service.

To assign an object to the element of this property use FromObjectAsJson<T>(T, JsonSerializerOptions).

To assign an already formatted json string to this property use FromString(String).

Examples:

• BinaryData.FromObjectAsJson("foo"): Creates a payload of "foo".
• BinaryData.FromString("\"foo\""): Creates a payload of "foo".
• BinaryData.FromObjectAsJson(new { key = "value" }): Creates a payload of { "key": "value" }.
• BinaryData.FromString("{\"key\": \"value\"}"): Creates a payload of { "key": "value" }.

The connection string. Type: string, SecureString or AzureKeyVaultSecretReference.

The length of time (in seconds) to wait for a connection to the server before terminating the attempt and generating an error. Type: integer.

The integration runtime reference.

True to return DateTime.MinValue for date or datetime columns that have disallowed values. Type: boolean.

Database name for connection. Type: string.

Linked service description.

The version of the MySQL driver. Type: string. V1 or empty for legacy driver, V2 for new driver. V1 can support connection string and property bag, V2 can only support connection string.

The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string.

Determines which column type (if any) should be read as a GUID. Type: string. None: No column types are automatically read as a Guid; Char36: All CHAR(36) columns are read/written as a Guid using lowercase hex with hyphens, which matches UUID.

Version of the linked service.

Parameters for linked service.

The Azure key vault secret reference of password in connection string.

The port for the connection. Type: integer.

Server name for connection. Type: string.

The path to the client’s SSL certificate file in PEM format. SslKey must also be specified. Type: string.

The path to the client’s SSL private key in PEM format. SslCert must also be specified. Type: string.

SSL mode for connection. Type: integer. 0: disable, 1: prefer, 2: require, 3: verify-ca, 4: verify-full.

When set to true, TINYINT(1) values are returned as booleans. Type: bool.

Username for authentication. Type: string.

Use system trust store for connection. Type: integer. 0: enable, 1: disable.

Reads one JSON value (including objects or arrays) from the provided reader and converts it to a model.

Writes the model to the provided Utf8JsonWriter.

Reads one JSON value (including objects or arrays) from the provided reader and converts it to a model.

Writes the model to the provided Utf8JsonWriter.

Converts the provided BinaryData into a model.

Gets the data interchange format (JSON, Xml, etc) that the model uses when communicating with the service.

Writes the model into a BinaryData.

Converts the provided BinaryData into a model.

Gets the data interchange format (JSON, Xml, etc) that the model uses when communicating with the service.

Writes the model into a BinaryData.