SqlSource Constructors

Definition

Namespace:

Microsoft.Azure.Management.DataFactory.Models

Assembly:

Microsoft.Azure.Management.DataFactory.dll

Package:

Microsoft.Azure.Management.DataFactory v8.0.0

Overloads

SqlSource()	Initializes a new instance of the SqlSource class.
SqlSource(IDictionary<String,Object>, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, SqlPartitionSettings)	Initializes a new instance of the SqlSource class.

SqlSource()

Initializes a new instance of the SqlSource class.

public SqlSource ();

Public Sub New ()

SqlSource(IDictionary<String,Object>, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, SqlPartitionSettings)

Initializes a new instance of the SqlSource class.

public SqlSource (System.Collections.Generic.IDictionary<string,object> additionalProperties = default, object sourceRetryCount = default, object sourceRetryWait = default, object maxConcurrentConnections = default, object disableMetricsCollection = default, object queryTimeout = default, object additionalColumns = default, object sqlReaderQuery = default, object sqlReaderStoredProcedureName = default, object storedProcedureParameters = default, object isolationLevel = default, object partitionOption = default, Microsoft.Azure.Management.DataFactory.Models.SqlPartitionSettings partitionSettings = default);

new Microsoft.Azure.Management.DataFactory.Models.SqlSource : System.Collections.Generic.IDictionary<string, obj> * obj * obj * obj * obj * obj * obj * obj * obj * obj * obj * obj * Microsoft.Azure.Management.DataFactory.Models.SqlPartitionSettings -> Microsoft.Azure.Management.DataFactory.Models.SqlSource

Public Sub New (Optional additionalProperties As IDictionary(Of String, Object) = Nothing, Optional sourceRetryCount As Object = Nothing, Optional sourceRetryWait As Object = Nothing, Optional maxConcurrentConnections As Object = Nothing, Optional disableMetricsCollection As Object = Nothing, Optional queryTimeout As Object = Nothing, Optional additionalColumns As Object = Nothing, Optional sqlReaderQuery As Object = Nothing, Optional sqlReaderStoredProcedureName As Object = Nothing, Optional storedProcedureParameters As Object = Nothing, Optional isolationLevel As Object = Nothing, Optional partitionOption As Object = Nothing, Optional partitionSettings As SqlPartitionSettings = Nothing)

Parameters

additionalProperties

IDictionary<String,Object>

Unmatched properties from the message are deserialized this collection

sourceRetryCount

Object

Source retry count. Type: integer (or Expression with resultType integer).

sourceRetryWait

Object

Source retry wait. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60|([0-5][0-9])):(60|([0-5][0-9])).

maxConcurrentConnections

Object

The maximum concurrent connection count for the source data store. Type: integer (or Expression with resultType integer).

disableMetricsCollection

Object

If true, disable data store metrics collection. Default is false. Type: boolean (or Expression with resultType boolean).

queryTimeout

Object

Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60|([0-5][0-9])):(60|([0-5][0-9])).

additionalColumns

Object

Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).

sqlReaderQuery

Object

SQL reader query. Type: string (or Expression with resultType string).

sqlReaderStoredProcedureName

Object

Name of the stored procedure for a SQL Database source. This cannot be used at the same time as SqlReaderQuery. Type: string (or Expression with resultType string).

storedProcedureParameters

Object

Value and type setting for stored procedure parameters. Example: "{Parameter1: {value: "1", type: "int"}}".

isolationLevel

Object

Specifies the transaction locking behavior for the SQL source. Allowed values: ReadCommitted/ReadUncommitted/RepeatableRead/Serializable/Snapshot. The default value is ReadCommitted. Type: string (or Expression with resultType string).

partitionOption

Object

The partition mechanism that will be used for Sql read in parallel. Possible values include: "None", "PhysicalPartitionsOfTable", "DynamicRange".

partitionSettings

SqlPartitionSettings

The settings that will be leveraged for Sql source partitioning.