SqlServerSink Class
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
A copy activity SQL server sink.
public class SqlServerSink : Azure.ResourceManager.DataFactory.Models.CopySink, System.ClientModel.Primitives.IJsonModel<Azure.ResourceManager.DataFactory.Models.SqlServerSink>, System.ClientModel.Primitives.IPersistableModel<Azure.ResourceManager.DataFactory.Models.SqlServerSink>public class SqlServerSink : Azure.ResourceManager.DataFactory.Models.CopySinktype SqlServerSink = class
inherit CopySink
interface IJsonModel<SqlServerSink>
interface IPersistableModel<SqlServerSink>type SqlServerSink = class
inherit CopySinkPublic Class SqlServerSink
Inherits CopySink
Implements IJsonModel(Of SqlServerSink), IPersistableModel(Of SqlServerSink)Public Class SqlServerSink
Inherits CopySink- Inheritance
- Implements
Constructors
| SqlServerSink() |
Initializes a new instance of SqlServerSink. |
Properties
| AdditionalProperties |
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:
|
| DisableMetricsCollection |
If true, disable data store metrics collection. Default is false. Type: boolean (or Expression with resultType boolean). (Inherited from CopySink) |
| MaxConcurrentConnections |
The maximum concurrent connection count for the sink data store. Type: integer (or Expression with resultType integer). (Inherited from CopySink) |
| PreCopyScript |
SQL pre-copy script. Type: string (or Expression with resultType string). |
| SinkRetryCount |
Sink retry count. Type: integer (or Expression with resultType integer). (Inherited from CopySink) |
| SinkRetryWait |
Sink retry wait. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60|([0-5][0-9])):(60|([0-5][0-9])). (Inherited from CopySink) |
| SqlWriterStoredProcedureName |
SQL writer stored procedure name. Type: string (or Expression with resultType string). |
| SqlWriterTableType |
SQL writer table type. Type: string (or Expression with resultType string). |
| SqlWriterUseTableLock |
Whether to use table lock during bulk copy. Type: boolean (or Expression with resultType boolean). |
| StoredProcedureParameters |
SQL stored procedure parameters. To assign an object to this property use FromObjectAsJson<T>(T, JsonSerializerOptions). To assign an already formatted json string to this property use FromString(String). Examples:
|
| StoredProcedureTableTypeParameterName |
The stored procedure parameter name of the table type. Type: string (or Expression with resultType string). |
| TableOption |
The option to handle sink table, such as autoCreate. For now only 'autoCreate' value is supported. Type: string (or Expression with resultType string). |
| UpsertSettings |
SQL upsert settings. |
| WriteBatchSize |
Write batch size. Type: integer (or Expression with resultType integer), minimum: 0. (Inherited from CopySink) |
| WriteBatchTimeout |
Write batch timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60|([0-5][0-9])):(60|([0-5][0-9])). (Inherited from CopySink) |
| WriteBehavior |
Write behavior when copying data into sql server. Type: string (or Expression with resultType string). |
Methods
| JsonModelWriteCore(Utf8JsonWriter, ModelReaderWriterOptions) | |
| JsonModelWriteCore(Utf8JsonWriter, ModelReaderWriterOptions) | (Inherited from CopySink) |
