SqlPlanGenerationOptions Members

Include Protected Members
Include Inherited Members

Represents SQL plan generation options.

The SqlPlanGenerationOptions type exposes the following members.

Constructors

	Name	Description
	SqlPlanGenerationOptions	Initializes a new instance of the SqlPlanGenerationOptions class.

Top

Methods

	Name	Description
	AddExcludedObjectTypeForSchemaCompare	Adds a new type to the excluded schema compare type list.
	CreateCopy	Creates a copy of this plan generation options object. (Overrides PlanGenerationOptions.CreateCopy().)
	Equals	Determines whether the specified Object is equal to the current Object. (Inherited from Object.)
	Finalize	Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection. (Inherited from Object.)
	FlushExcludedObjectTypeForSchemaCompare	Clears the excluded schema compare type list and adds ISqlDynamicColumnSource to it.
	GetHashCode	Serves as a hash function for a particular type. (Inherited from Object.)
	GetPropertyClassesToExcludeFromComparison	Returns a collection of property classes to exclude from the comparison.
	GetRelationshipClassesToExcludeFromComparison	Returns a collection of relationship classes to exclude from the comparison.
	GetType	Gets the Type of the current instance. (Inherited from Object.)
	MemberwiseClone	Creates a shallow copy of the current Object. (Inherited from Object.)
	OnExtensionHandle	Used to create a parser. (Overrides PlanGenerationOptions.OnExtensionHandle().)
	OnInitialize	Called on initialization. (Overrides PlanGenerationOptions.OnInitialize().)
	SetExtensionHandle	Sets the extension handle. (Inherited from PlanGenerationOptions.)
	ToString	Returns a String that represents the current Object. (Inherited from Object.)
	TryLoadSourceSqlCmdVariables	Returns whether the method loaded the source SQL command variables from the given variables file.
	TryLoadTargetSqlCmdVariables	Returns whether the method loaded the target SQL command variables from the given variables file.

Top

Fields

	Name	Description
	CurrentVersion	Value is RosarioVersion.
	ExcludedTypeValueName	Value is "ExcludedType".
	PlanGenerationType	Value is "PlanGenerationType".
	RosarioVersion	Value is "1".
	VersionElementName	Value is "Version".

Top

Properties

	Name	Description
	AbortOnFirstError	Gets whether to abort the plan on first error.
	BackupDatabaseBeforeChanges	Gets or sets whether to back up the database before making changes.
	BlockOnPossibleDataLoss	Gets whether to block action on possible data loss.
	CommentOutSetVarDeclarations	Gets or sets whether to comment out setvar declarations.
	ComparerConfiguration	Gets the model comparer configuration. (Overrides PlanGenerationOptions.ComparerConfiguration.)
	CreateNewDatabase	Gets or sets whether a database is created. (Inherited from PlanGenerationOptions.)
	DatabaseSchemaProvider	Gets the database schema provider.
	DeployDatabaseInSingleUserMode	Gets or sets whether to deploy a database in single-user mode.
	DropObjectsNotInSource	Gets or sets whether objects not in source are dropped. (Inherited from PlanGenerationOptions.)
	EnforceMinimalDependencies	Gets or sets whether to enforce minimal dependencies.
	ExcludedModelElements	Gets or sets excluded model elements. (Inherited from PlanGenerationOptions.)
	ExcludedObjectTypesForSchemaCompare	Gets a collection of excluded object types.
	ExtensionHandle	Gets or sets the extension handle. (Inherited from PlanGenerationOptions.)
	GenerateDatabaseOptions	Gets or sets whether to generate database options.
	GenerateDeployStateChecks	Gets or sets whether to generate deploy state checks.
	IgnoreAnsiNulls	Gets whether to ignore ANSI nulls.
	IgnoreAutoGeneratedNames	Gets whether to ignore auto-generated names.
	IgnoreBodyDependencies	Gets or sets whether to ignore body dependencies.
	IgnoreCollations	Gets whether to ignore collations.
	IgnoreColumnCollation	Gets whether to ignore column collation.
	IgnoreComments	Gets whether to ignore comments.
	IgnoreDmlTriggerOrder	Gets whether to ignore DML trigger order.
	IgnoreDmlTriggerState	Gets whether to ignore DML trigger state.
	IgnoreExtendedProperties	Gets or sets whether to ignore SQL extended properties.
	IgnoreFileAndLogFilePath	Gets whether to ignore file paths.
	IgnoreFilegroupPlacement	Gets whether to ignore file group placement.
	IgnoreFileSize	Gets whether to ignore file size.
	IgnoreFillFactor	Gets whether to ignore fill factor.
	IgnoreFullTextCatalogFilePath	Gets whether to ignore full text catalog file path.
	IgnoreIdentitySeed	Gets whether to ignore identity seed.
	IgnoreIncrement	Gets whether to ignore increment.
	IgnoreIndexOptions	Gets whether to ignore index options.
	IgnoreIndexPadding	Gets whether to ignore index padding.
	IgnoreKeywordCasing	Gets or sets whether to ignore keyword casing.
	IgnoreLockHintsOnIndexes	Gets whether to ignore lock hints on indexes.
	IgnoreLoginSids	Gets whether to ignore login SIDs.
	IgnorePasswords	Gets whether to ignore passwords.
	IgnorePermissions	Gets or sets whether to ignore SQL permissions.
	IgnoreQuotedIdentifiers	Gets whether to ignore quoted identifiers.
	IgnoreRoleMembership	Gets whether to ignore role membership.
	IgnoreSemicolonBetweenStatements	Gets or sets whether to ignore semicolons between statements.
	IgnoreStatisticsSample	Gets or sets whether to ignore SQL statistics sample values.
	IgnoreTableOptions	Gets whether to ignore table options.
	IgnoreUserSettingsObjects	Gets whether to ignore user settings objects.
	IgnoreWhitespace	Gets whether to ignore whitespace.
	IgnoreWithNocheckOnCheckConstraints
	IgnoreWithNocheckOnForeignKeys
	IncludeTransactionalScripts	Gets or sets whether to include transactional scripts.
	OnlyCompareElementsInSource	Gets or sets whether to only compare elements in the source.
	OverriddenConnectionSettings	Gets the SQL plan generation options connection settings object.
	OverrideSevenSetOptions	Gets whether to override the seven SET options.
	SerializationData	Returns a list of options to serialize. (Overrides PlanGenerationOptions.SerializationData.)
	SetAnsiNulls	Gets whether SET ANSI_NULLS is enabled.
	SetAnsiPadding	Gets whether SET ANSI_PADDING is enabled.
	SetAnsiWarnings	Gets whether SET ANSI_WARNINGS is enabled.
	SetArithAbort	Gets whether SET ARITHABORT is enabled.
	SetConcatNullYieldsNull	Gets whether SET CONCAT_NULL_YIELDS_NULL is enabled.
	SetNumericRoundAbort	Gets whether SET NUMERIC_ROUNDABORT is enabled.
	SetQuotedIdentifier	Gets whether SET QUOTED_IDENTIFIER is enabled.
	SourceSetVariables	Returns a list of source SET variables.
	TargetConnectionString	Gets or sets a target connection string. (Inherited from PlanGenerationOptions.)
	TargetDatabaseName	Gets or sets a target database name. (Inherited from PlanGenerationOptions.)
	TargetSetVariables	Returns a list of target SET variables.
	TreatVerificationErrorsAsWarnings	Gets or sets whether to treat verification errors as warnings. (Inherited from PlanGenerationOptions.)
	UnmodifiableObjectWarnings
	UseSourceCollation	Gets or sets whether to use source collation.
	VerifyDeployment	Gets or sets whether to verify deployment. (Inherited from PlanGenerationOptions.)

Top

See Also

Reference

SqlPlanGenerationOptions Class

Microsoft.Data.Schema.Sql.Build Namespace