Table of Contents

Class SqlDatabase

Namespace
CENTREL.XIA.Configuration.Types
Assembly
CENTREL.XIA.Configuration.Types.dll

Represents a SQL server database.

public class SqlDatabase : BaseTypeSection, IComparable<SqlDatabase>
Inheritance
SqlDatabase
Implements

Constructors

SqlDatabase()

Initializes a new instance of the CENTREL.XIA.Configuration.Types.SqlDatabase class.

public SqlDatabase()

Properties

Assemblies

Gets or sets the assemblies defined in the database.

public SqlAssemblies Assemblies { get; set; }

Property Value

SqlAssemblies

ChangeTracking

Gets or sets the change tracking settings for the database.

public SqlDatabaseChangeTracking ChangeTracking { get; set; }

Property Value

SqlDatabaseChangeTracking

CollectionIndex

Gets the collection index used by the data comparer.

[Browsable(false)]
public string CollectionIndex { get; }

Property Value

string

CreationScript

Gets or sets the script used to create the database.

public SqlScript CreationScript { get; set; }

Property Value

SqlScript

DataFiles

Gets the data files for the database in all file groups.

public SqlDataFileCollection DataFiles { get; }

Property Value

SqlDataFileCollection

DisplayStatus

Gets or sets the display status of the database.

public string DisplayStatus { get; set; }

Property Value

string

ExtendedProperties

Gets or sets the extended properties for the database.

public SqlExtendedProperties ExtendedProperties { get; set; }

Property Value

SqlExtendedProperties

FileGroups

Gets or sets the file groups configured for the database. This applies to on-premises installations of SQL Server.

public SqlDatabaseFileGroups FileGroups { get; set; }

Property Value

SqlDatabaseFileGroups

Files

Gets all data and log files for the database.

public SqlFileCollection Files { get; }

Property Value

SqlFileCollection

General

Gets or sets the general settings of the database.

public SqlDatabaseGeneralSettings General { get; set; }

Property Value

SqlDatabaseGeneralSettings

LogFiles

Gets or sets the log files configured for the database.

public SqlLogFiles LogFiles { get; set; }

Property Value

SqlLogFiles

Mirroring

Gets or sets the database mirroring settings.

public SqlDatabaseMirroringSettings Mirroring { get; set; }

Property Value

SqlDatabaseMirroringSettings

Options

Gets or sets the options for the database.

public SqlDatabaseOptions Options { get; set; }

Property Value

SqlDatabaseOptions

Permissions

Gets or sets the permissions for the database.

public SqlPermissions Permissions { get; set; }

Property Value

SqlPermissions

QueryStore

Gets or sets the query store settings for the database. This applies to Azure and on-premises SQL Server 2016 and above.

public SqlDatabaseQueryStoreSettings QueryStore { get; set; }

Property Value

SqlDatabaseQueryStoreSettings

StoredProcedures

Gets or sets the stored procedures for the database.

public SqlStoredProcedures StoredProcedures { get; set; }

Property Value

SqlStoredProcedures

Tables

Gets or sets the tables for the database.

public SqlTables Tables { get; set; }

Property Value

SqlTables

UserDefinedFunctions

Gets or sets the user defined functions for the database.

public SqlUserDefinedFunctions UserDefinedFunctions { get; set; }

Property Value

SqlUserDefinedFunctions

Users

Gets or sets the users configured for the database.

public SqlDatabaseUsers Users { get; set; }

Property Value

SqlDatabaseUsers

Views

Gets or sets the views configured for the database.

public SqlViews Views { get; set; }

Property Value

SqlViews

Methods

Clone()

Returns a CENTREL.XIA.Configuration.Types.SqlDatabase cloned from this object.

public SqlDatabase Clone()

Returns

SqlDatabase

A CENTREL.XIA.Configuration.Types.SqlDatabase.

CompareTo(SqlDatabase)

Compares two CENTREL.XIA.Configuration.Types.SqlDatabase objects to allow sorting alphabetically by name.

public int CompareTo(SqlDatabase other)

Parameters

other SqlDatabase

The CENTREL.XIA.Configuration.Types.SqlDatabase to compare to.

Returns

int

The sort order of the two CENTREL.XIA.Configuration.Types.SqlDatabase objects.

ToString()

Returns the name of the database.

public override string ToString()

Returns

string

The name of the database.