SqlServerSource Constructors

Definition

Overloads

SqlServerSource()

Initializes a new instance of the SqlServerSource class.

SqlServerSource(IDictionary<String,Object>, Object, Object, Object, Object, Object, IList<AdditionalColumns>, Object, Object, IDictionary<String,StoredProcedureParameter>, Object, Object, SqlPartitionSettings)

Initializes a new instance of the SqlServerSource class.

SqlServerSource()

Initializes a new instance of the SqlServerSource class.

public SqlServerSource ();
Public Sub New ()

Applies to

SqlServerSource(IDictionary<String,Object>, Object, Object, Object, Object, Object, IList<AdditionalColumns>, Object, Object, IDictionary<String,StoredProcedureParameter>, Object, Object, SqlPartitionSettings)

Initializes a new instance of the SqlServerSource class.

public SqlServerSource (System.Collections.Generic.IDictionary<string,object> additionalProperties = default, object sourceRetryCount = default, object sourceRetryWait = default, object maxConcurrentConnections = default, object disableMetricsCollection = default, object queryTimeout = default, System.Collections.Generic.IList<Microsoft.Azure.Management.DataFactory.Models.AdditionalColumns> additionalColumns = default, object sqlReaderQuery = default, object sqlReaderStoredProcedureName = default, System.Collections.Generic.IDictionary<string,Microsoft.Azure.Management.DataFactory.Models.StoredProcedureParameter> storedProcedureParameters = default, object produceAdditionalTypes = default, object partitionOption = default, Microsoft.Azure.Management.DataFactory.Models.SqlPartitionSettings partitionSettings = default);
new Microsoft.Azure.Management.DataFactory.Models.SqlServerSource : System.Collections.Generic.IDictionary<string, obj> * obj * obj * obj * obj * obj * System.Collections.Generic.IList<Microsoft.Azure.Management.DataFactory.Models.AdditionalColumns> * obj * obj * System.Collections.Generic.IDictionary<string, Microsoft.Azure.Management.DataFactory.Models.StoredProcedureParameter> * obj * obj * Microsoft.Azure.Management.DataFactory.Models.SqlPartitionSettings -> Microsoft.Azure.Management.DataFactory.Models.SqlServerSource
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 IList(Of AdditionalColumns) = Nothing, Optional sqlReaderQuery As Object = Nothing, Optional sqlReaderStoredProcedureName As Object = Nothing, Optional storedProcedureParameters As IDictionary(Of String, StoredProcedureParameter) = Nothing, Optional produceAdditionalTypes As Object = Nothing, Optional partitionOption As Object = Nothing, Optional partitionSettings As SqlPartitionSettings = Nothing)

Parameters

additionalProperties
System.Collections.Generic.IDictionary<System.String,System.Object>

Unmatched properties from the message are deserialized this collection

sourceRetryCount
System.Object

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

sourceRetryWait
System.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
System.Object

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

disableMetricsCollection
System.Object

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

queryTimeout
System.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
System.Collections.Generic.IList<AdditionalColumns>

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

sqlReaderQuery
System.Object

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

sqlReaderStoredProcedureName
System.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
System.Collections.Generic.IDictionary<System.String,StoredProcedureParameter>

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

produceAdditionalTypes
System.Object

Which additional types to produce.

partitionOption
System.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.

Applies to