Class SqlDatabaseOptions
- Namespace
- CENTREL.XIA.Configuration.Types
- Assembly
- CENTREL.XIA.Configuration.Types.dll
Represents the options for a SQL database.
public class SqlDatabaseOptions : BaseTypeSection- Inheritance
-
SqlDatabaseOptions
Constructors
SqlDatabaseOptions()
Initializes a new instance of the CENTREL.XIA.Configuration.Types.SqlDatabaseOptions class.
public SqlDatabaseOptions()Properties
AllowSnapshotIsolation
Gets or sets whether to allow snapshot isolation. This applies to SQL Server 2012 and above.
public BooleanOption AllowSnapshotIsolation { get; set; }Property Value
AnsiNullDefault
Gets or sets the default ANSI NULL setting value.
public BooleanOption AnsiNullDefault { get; set; }Property Value
AnsiNullsEnabled
Gets or sets the ANSI NULLS enabled setting value.
public BooleanOption AnsiNullsEnabled { get; set; }Property Value
AnsiPaddingEnabled
Gets or sets the ANSI padding enabled setting value.
public BooleanOption AnsiPaddingEnabled { get; set; }Property Value
AnsiWarningsEnabled
Gets or sets the ANSI warnings enabled setting value.
public BooleanOption AnsiWarningsEnabled { get; set; }Property Value
ArithmeticAbortEnabled
Gets or sets the arithmetic abort enabled setting value.
public BooleanOption ArithmeticAbortEnabled { get; set; }Property Value
AutoClose
Gets or sets whether the database is configured to close automatically. This setting isn't available on Azure system databases.
public BooleanOption AutoClose { get; set; }Property Value
AutoCreateIncrementalStatistics
Gets or sets whether the database is configured to automatically create incremental statistics. This applies to SQL Server 2014 and above.
public BooleanOption AutoCreateIncrementalStatistics { get; set; }Property Value
AutoCreateStatistics
Gets or sets whether the database is configured to automatically create statistics.
public BooleanOption AutoCreateStatistics { get; set; }Property Value
AutoShrink
Gets or sets whether the database is configured to automatically shrink.
public BooleanOption AutoShrink { get; set; }Property Value
AutoUpdateStatistics
Gets or sets whether the database is configured to automatically update statistics.
public BooleanOption AutoUpdateStatistics { get; set; }Property Value
AutoUpdateStatisticsAsynchronously
Gets or sets whether the database is configured to automatically update statistics asynchronously.
public BooleanOption AutoUpdateStatisticsAsynchronously { get; set; }Property Value
Azure
Gets or sets the Azure related database options. This only applies to Azure hosted databases.
public SqlDatabaseAzureOptions Azure { get; set; }Property Value
CloseCursorsOnCommitEnabled
Gets or sets the close cursors on commit enabled setting.
public BooleanOption CloseCursorsOnCommitEnabled { get; set; }Property Value
CompatibilityLevel
Gets or sets the compatibility level of the database.
public SqlDatabaseCompatibilityLevel CompatibilityLevel { get; set; }Property Value
CompatibilityLevelString
Gets the compatibility level of the database as a human readable string.
public string CompatibilityLevelString { get; set; }Property Value
ConcatenateNullYieldsNull
Gets or sets the concatenate null yields null setting value.
public BooleanOption ConcatenateNullYieldsNull { get; set; }Property Value
Containment
Gets or sets the containment options for the database. This applies to on-premises SQL Server 2012 and above.
public SqlDatabaseContainmentOptions Containment { get; set; }Property Value
DatabaseOwnershipChaining
Gets or sets the cross database ownership chaining enabled setting.
public BooleanOption DatabaseOwnershipChaining { get; set; }Property Value
DatabaseScoped
Gets or sets the database scoped configuration options. This applies to Azure and SQL Server 2016 and above.
public SqlDatabaseScopedConfigurationOptions DatabaseScoped { get; set; }Property Value
DateCorrelationOptimization
Gets or sets whether date correlation optimization is enabled.
public BooleanOption DateCorrelationOptimization { get; set; }Property Value
DefaultCursorString
Gets the default cursor.
public string DefaultCursorString { get; set; }Property Value
DelayedDurability
Gets or sets the delayed durability option. This applies to on-premises SQL Server 2014 and above.
public SqlDatabaseDelayedDurability DelayedDurability { get; set; }Property Value
DelayedDurabilityString
Gets the delayed durability option as a human readable string.
public string DelayedDurabilityString { get; set; }Property Value
FilestreamDirectoryName
Gets or sets the filestream directory name. This applies to on-premises SQL Server 2012 and above.
public string FilestreamDirectoryName { get; set; }Property Value
FilestreamNonTransactedAccess
Gets or sets the filestream non transacted access type. This applies to on-premises SQL Server 2012 and above.
public SqlDatabaseFilestreamNonTransactedAccessType FilestreamNonTransactedAccess { get; set; }Property Value
FilestreamNonTransactedAccessString
Gets the filestream non transacted access type as human readable string. This applies to on-premises SQL Server 2012 and above.
public string FilestreamNonTransactedAccessString { get; set; }Property Value
IsParameterizationForced
Gets or sets the value of the is parameterization forced setting.
public BooleanOption IsParameterizationForced { get; set; }Property Value
IsReadCommittedSnapshotOn
Gets or sets the is read committed snapshot on setting value. This applies to SQL Server 2012 and above.
public BooleanOption IsReadCommittedSnapshotOn { get; set; }Property Value
LocalCursorsDefault
Gets or sets whether the default cursor is local.
public BooleanOption LocalCursorsDefault { get; set; }Property Value
NumericRoundAbortEnabled
Gets or sets the value of the numeric round abort enabled setting.
public BooleanOption NumericRoundAbortEnabled { get; set; }Property Value
PageVerify
Gets or sets the page verify setting for the database. This only applies to on-premises SQL Server.
public SqlDatabasePageVerify PageVerify { get; set; }Property Value
PageVerifyString
Gets the page verify setting for the database as a human readable string.
public string PageVerifyString { get; set; }Property Value
ParameterizationString
Gets the value of the is parameterization setting as a human readable string.
public string ParameterizationString { get; set; }Property Value
QuotedIdentifiersEnabled
Gets or sets the value of the quoted identifiers enabled setting.
public BooleanOption QuotedIdentifiersEnabled { get; set; }Property Value
RecoveryModel
Gets or sets the recovery model for the database. This only applies to on-premises SQL Server.
public SqlDatabaseRecoveryModel RecoveryModel { get; set; }Property Value
RecoveryModelString
Gets the recovery model for the database as a human readable string. This only applies to on-premises SQL Server.
public string RecoveryModelString { get; set; }Property Value
RecursiveTriggersEnabled
Gets or sets the value of the recursive triggers enabled setting.
public BooleanOption RecursiveTriggersEnabled { get; set; }Property Value
ServiceBroker
Gets or sets the service broker options for a SQL database. This applies to on-premises SQL instances.
public SqlDatabaseServiceBrokerOptions ServiceBroker { get; set; }Property Value
State
Gets or sets the state options for the databse.
public SqlDatabaseStateOptions State { get; set; }Property Value
TargetRecoveryTime
Gets or sets the target recovery time in seconds. This only applies to on-premises SQL Server 2012 and above.
public int TargetRecoveryTime { get; set; }Property Value
Trustworthy
Gets or sets whether the database is trustworthy.
public BooleanOption Trustworthy { get; set; }Property Value
VarDecimalStorageFormatEnabled
Gets or sets the value of the vardecimal storage format enabled setting.
public BooleanOption VarDecimalStorageFormatEnabled { get; set; }Property Value
Methods
FromXml(string)
Returns a CENTREL.XIA.Configuration.Types.SqlDatabaseOptions class from the specified XML.
public static SqlDatabaseOptions FromXml(string xml)Parameters
xmlstringThe XML representation of the object.
Returns
- SqlDatabaseOptions
A CENTREL.XIA.Configuration.Types.SqlDatabaseOptions class.