TSqlModel Methods
Updated: April 20, 2017
Assembly: Microsoft.SqlServer.Dac.Extensions (in Microsoft.SqlServer.Dac.Extensions.dll)
| Name | Description | |
|---|---|---|
 | 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 method instead. |
| AddObjects(String^, TSqlObjectOptions^) | Adds 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 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 method instead. |
| AddObjects(TSqlScript^, TSqlObjectOptions^) | Adds 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 method instead. |
| AddOrUpdateObjects(String^, String^, TSqlObjectOptions^) | Adds or updates the objects defined for a specified sourceName with the objects defined in the inputScript. If any objects were previously added with the same sourceName these will be completely replaced The object definitions are 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. |
| AddOrUpdateObjects(TSqlScript^, String^, TSqlObjectOptions^) | Adds or updates the objects defined for a specified sourceName with the objects defined in the inputScript. If any objects were previously added with the same sourceName these will be completely replaced The object definitions are based on the contents of a TSqlScript object plus additional metadata defined by a TSqlObjectOptions object The script should consist of valid TSql DDL statements. |
| CheckVersionCompatibility(SqlServerVersion, CancellationToken) | |
| ConvertToScriptedObject(TSqlObject^, String^) | |
| CopyModelOptions() | Copies the DatabaseOptions for the model to a TSqlModelOptions object. This is useful if you wish to duplicate the options for a model when creating a new model. |
| DeleteObjects(String^) | Deletes any objects that were added to the model with the specified sourceName. |
| Dispose() | Releases all resources used by the TSqlModel object. |
| Equals(Object^) | (Inherited from Object.) |
| GetHashCode() | (Inherited from Object.) |
| GetModelErrors() | |
| GetObject(ModelTypeClass^, ObjectIdentifier^, DacQueryScopes) | Returns TSqlObjects of the specified objectTypetype and ididentity. Only top level ModelTypeClass types are supported by this method - the objectTypetype parameter must be in the types returned from the TopLevelTypes method or the call will fail. |
| GetObjects(DacQueryScopes, array<ModelTypeClass^>^) | Returns all TSqlObjects matching the list of typeFilters. Only top level ModelTypeClass types are supported by this method - all types in the typeFilterstype parameter must be present in the TopLevelTypes or the call will fail. |
| GetObjects(ModelTypeClass^, ObjectIdentifier^, DacQueryScopes) | Returns all TSqlObjects that match the ModelTypeClass and ObjectIdentifier. Only top level ModelTypeClass types are supported by this method - the objectTypetype parameter must be in the types returned from the TopLevelTypes method or the call will fail. |
| GetObjects(String^, array<ModelTypeClass^>^) | |
| GetType() | (Inherited from Object.) |
 | LoadFromDacpac(Stream^, ModelLoadOptions^) | Loads a model from a DacPackage or BacPackage using the specified options to configure what kind of storage to use, and whether to load a script-backed model or not. |
| LoadFromDacpac(Stream^, ModelLoadOptions^, CancellationToken) | |
| LoadFromDacpac(String^, ModelLoadOptions^) | Loads a model from a DacPackage or BacPackage using the specified options to configure what kind of storage to use, and whether to load a script-backed model or not. |
| LoadFromDacpac(String^, ModelLoadOptions^, CancellationToken) | |
| LoadFromDatabase(String^, ModelExtractOptions^, Nullable<CancellationToken>, IUniversalAuthProvider^) | |
| LoadFromDatabase(String^, SecureString^, ModelExtractOptions^, Nullable<CancellationToken>) | |
| LoadFromDatabaseForUniversalAuth(String^, IUniversalAuthProvider^, ModelExtractOptions^, Nullable<CancellationToken>) | |
| ToString() | (Inherited from Object.) |
| Validate() | Validates the model and returns a list of messages with any errors/warnings. |