Partager via


TSqlModel.AddObjects Method

Definition

Overloads

AddObjects(TSqlScript)

Adds objects to the model based on the contents of a TSqlScript object. The script should be valid TSql with no parse errors.

Objects added using this method cannot be updated or deleted at a later point as update/delete requires a script name to be specified when adding the objects. If this is a requirement use the AddOrUpdateObjects(TSqlScript, String, TSqlObjectOptions) method instead.

AddObjects(String)

Adds objects to the model based on the contents of a TSql Script string. The script should consist of valid TSql DDL statements.

Objects added using this method cannot be updated or deleted at a later point as update/delete requires a script name to be specified when adding the objects. If this is a requirement use the AddOrUpdateObjects(String, String, TSqlObjectOptions) method instead.

AddObjects(TSqlScript, TSqlObjectOptions)

Add Objects to the model based on the contents of a TSqlScript object, plus additional metadata defined by a TSqlObjectOptions object The script should be valid TSql with no parse errors.

Objects added using this method cannot be updated or deleted at a later point as update/delete requires a script name to be specified when adding the objects. If this is a requirement use the AddOrUpdateObjects(TSqlScript, String, TSqlObjectOptions) method instead.

AddObjects(String, TSqlObjectOptions)

Add Objects to the model based on the contents of a TSql Script string, plus additional metadata defined by a TSqlObjectOptions object The script should consist of valid TSql DDL statements.

Objects added using this method cannot be updated or deleted at a later point as update/delete requires a script name to be specified when adding the objects. If this is a requirement use the AddOrUpdateObjects(String, String, TSqlObjectOptions) method instead.

AddObjects(TSqlScript)

Adds objects to the model based on the contents of a TSqlScript object. The script should be valid TSql with no parse errors.

Objects added using this method cannot be updated or deleted at a later point as update/delete requires a script name to be specified when adding the objects. If this is a requirement use the AddOrUpdateObjects(TSqlScript, String, TSqlObjectOptions) method instead.

public void AddObjects (Microsoft.SqlServer.TransactSql.ScriptDom.TSqlScript inputScript);
member this.AddObjects : Microsoft.SqlServer.TransactSql.ScriptDom.TSqlScript -> unit
Public Sub AddObjects (inputScript As TSqlScript)

Parameters

inputScript
TSqlScript

The TSqlScript to add

Exceptions

If the supplied inputScript is null.

If communication with the Microsoft.SqlServer.Dac.Model.TSqlObjectService fails.

Applies to

AddObjects(String)

Adds objects to the model based on the contents of a TSql Script string. The script should consist of valid TSql DDL statements.

Objects added using this method cannot be updated or deleted at a later point as update/delete requires a script name to be specified when adding the objects. If this is a requirement use the AddOrUpdateObjects(String, String, TSqlObjectOptions) method instead.

public void AddObjects (string inputScript);
member this.AddObjects : string -> unit
Public Sub AddObjects (inputScript As String)

Parameters

inputScript
String

Script containing TSql DDL statements

Exceptions

If the supplied inputScript is null.

If communication with the Microsoft.SqlServer.Dac.Model.TSqlObjectService fails.

Applies to

AddObjects(TSqlScript, TSqlObjectOptions)

Add Objects to the model based on the contents of a TSqlScript object, plus additional metadata defined by a TSqlObjectOptions object The script should be valid TSql with no parse errors.

Objects added using this method cannot be updated or deleted at a later point as update/delete requires a script name to be specified when adding the objects. If this is a requirement use the AddOrUpdateObjects(TSqlScript, String, TSqlObjectOptions) method instead.

public void AddObjects (Microsoft.SqlServer.TransactSql.ScriptDom.TSqlScript inputScript, Microsoft.SqlServer.Dac.Model.TSqlObjectOptions options);
member this.AddObjects : Microsoft.SqlServer.TransactSql.ScriptDom.TSqlScript * Microsoft.SqlServer.Dac.Model.TSqlObjectOptions -> unit
Public Sub AddObjects (inputScript As TSqlScript, options As TSqlObjectOptions)

Parameters

inputScript
TSqlScript

The TSqlScript to add

options
TSqlObjectOptions

Options defining how to interpret the script

Exceptions

If the supplied inputScript is null.

If communication with the Microsoft.SqlServer.Dac.Model.TSqlObjectService fails.

Applies to

AddObjects(String, TSqlObjectOptions)

Add Objects to the model based on the contents of a TSql Script string, plus additional metadata defined by a TSqlObjectOptions object The script should consist of valid TSql DDL statements.

Objects added using this method cannot be updated or deleted at a later point as update/delete requires a script name to be specified when adding the objects. If this is a requirement use the AddOrUpdateObjects(String, String, TSqlObjectOptions) method instead.

public void AddObjects (string inputScript, Microsoft.SqlServer.Dac.Model.TSqlObjectOptions options);
member this.AddObjects : string * Microsoft.SqlServer.Dac.Model.TSqlObjectOptions -> unit
Public Sub AddObjects (inputScript As String, options As TSqlObjectOptions)

Parameters

inputScript
String

Script containing TSql DDL statements

options
TSqlObjectOptions

Options defining how to interpret the script

Exceptions

If the supplied inputScript is null.

If communication with the Microsoft.SqlServer.Dac.Model.TSqlObjectService fails.

Applies to