TSqlModel Constructors
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.
Overloads
| TSqlModel(String) |
Loads a model from a DacPackage or BacPackage. This is equivalent to calling LoadFromDacpac(String, ModelLoadOptions) with default values. |
| TSqlModel(SqlServerVersion, TSqlModelOptions) |
Creates an empty model that targets a specific SqlServerVersion |
| TSqlModel(String, DacSchemaModelStorageType) |
Loads a model from a DacPackage or BacPackage. This is equivalent to calling LoadFromDacpac(String, ModelLoadOptions) with default values for
everything except the |
| TSqlModel(String, DacSchemaModelStorageType, CancellationToken) |
Loads a model from a DacPackage or BacPackage. This is equivalent to calling LoadFromDacpac(String, ModelLoadOptions) with default values for
everything except the |
TSqlModel(String)
Loads a model from a DacPackage or BacPackage.
This is equivalent to calling LoadFromDacpac(String, ModelLoadOptions) with default values.
public TSqlModel (string fileName);new Microsoft.SqlServer.Dac.Model.TSqlModel : string -> Microsoft.SqlServer.Dac.Model.TSqlModelPublic Sub New (fileName As String)Parameters
- fileName
- String
File path to package.
Exceptions
If there are problems loading the package from the specified fileName.
This may occur if the package does not load correctly or if references required by
the package are not found in either the same directory as the package, or using the original path
to the reference.
Remarks
By default DacSchemaModelStorageType.Memory is used for the model storage format. The dacpac model will not be script-backed as the LoadAsScriptBackedModel will be set to false. Using LoadFromDacpac(String, ModelLoadOptions) with LoadAsScriptBackedModel set to true is recommended if the model will be used by the CodeAnalysisService for static code analysis.
Applies to
TSqlModel(SqlServerVersion, TSqlModelOptions)
Creates an empty model that targets a specific SqlServerVersion
public TSqlModel (Microsoft.SqlServer.Dac.Model.SqlServerVersion modelTargetVersion, Microsoft.SqlServer.Dac.Model.TSqlModelOptions modelCreationOptions);new Microsoft.SqlServer.Dac.Model.TSqlModel : Microsoft.SqlServer.Dac.Model.SqlServerVersion * Microsoft.SqlServer.Dac.Model.TSqlModelOptions -> Microsoft.SqlServer.Dac.Model.TSqlModelPublic Sub New (modelTargetVersion As SqlServerVersion, modelCreationOptions As TSqlModelOptions)Parameters
- modelTargetVersion
- SqlServerVersion
The version of SQL Server to target
- modelCreationOptions
- TSqlModelOptions
Options defining model properties, including the collation and how to store the model (in memory or file backed)
Applies to
TSqlModel(String, DacSchemaModelStorageType)
Loads a model from a DacPackage or BacPackage.
This is equivalent to calling LoadFromDacpac(String, ModelLoadOptions) with default values for
everything except the modelStorageType.
public TSqlModel (string fileName, Microsoft.SqlServer.Dac.DacSchemaModelStorageType modelStorageType);new Microsoft.SqlServer.Dac.Model.TSqlModel : string * Microsoft.SqlServer.Dac.DacSchemaModelStorageType -> Microsoft.SqlServer.Dac.Model.TSqlModelPublic Sub New (fileName As String, modelStorageType As DacSchemaModelStorageType)Parameters
- fileName
- String
File path to package.
- modelStorageType
- DacSchemaModelStorageType
Backing storage type for package instance.
Exceptions
If there are problems loading the package from the specified fileName.
This may occur if the package does not load correctly or if references required by
the package are not found in either the same directory as the package, or using the original path
to the reference.
Remarks
The dacpac model will not be script-backed as the LoadAsScriptBackedModel will be set to false. Using LoadFromDacpac(String, ModelLoadOptions) with LoadAsScriptBackedModel set to true is recommended if the model will be used by the CodeAnalysisService for static code analysis.
Applies to
TSqlModel(String, DacSchemaModelStorageType, CancellationToken)
Loads a model from a DacPackage or BacPackage.
This is equivalent to calling LoadFromDacpac(String, ModelLoadOptions) with default values for
everything except the modelStorageType.
public TSqlModel (string fileName, Microsoft.SqlServer.Dac.DacSchemaModelStorageType modelStorageType, System.Threading.CancellationToken cancellationToken);new Microsoft.SqlServer.Dac.Model.TSqlModel : string * Microsoft.SqlServer.Dac.DacSchemaModelStorageType * System.Threading.CancellationToken -> Microsoft.SqlServer.Dac.Model.TSqlModelPublic Sub New (fileName As String, modelStorageType As DacSchemaModelStorageType, cancellationToken As CancellationToken)Parameters
- fileName
- String
File path to package.
- modelStorageType
- DacSchemaModelStorageType
Backing storage type for package instance.
- cancellationToken
- CancellationToken
A token used for cancelling model loading.
Exceptions
If there are problems loading the package from the specified fileName.
This may occur if the package does not load correctly or if references required by
the package are not found in either the same directory as the package, or using the original path
to the reference.
When the load operation is canceled.
Remarks
The dacpac model will not be script-backed as the LoadAsScriptBackedModel will be set to false. Using LoadFromDacpac(String, ModelLoadOptions) with LoadAsScriptBackedModel set to true is recommended if the model will be used by the CodeAnalysisService for static code analysis.