Table of Contents

Class SqlDatabaseGeneralSettings

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

Represents the general settings for a SQL database.

public class SqlDatabaseGeneralSettings : BaseTypeSection
Inheritance
SqlDatabaseGeneralSettings

Constructors

SqlDatabaseGeneralSettings()

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

public SqlDatabaseGeneralSettings()

Properties

Collation

Gets or sets the collation of the database.

public string Collation { get; set; }

Property Value

string

DateCreated

Gets or sets the date and time the database was created.

public DateTime DateCreated { get; set; }

Property Value

DateTime

Description

Gets or sets the description of the database.

public string Description { get; set; }

Property Value

string

IsAccessible

Gets or sets whether the database is accessible.

public BooleanOption IsAccessible { get; set; }

Property Value

BooleanOption

IsDatabaseSnapshot

Gets or sets whether the database is a database snapshot.

public BooleanOption IsDatabaseSnapshot { get; set; }

Property Value

BooleanOption

IsFullTextEnabled

Gets or sets whether full text indexing is enabled.

public BooleanOption IsFullTextEnabled { get; set; }

Property Value

BooleanOption

IsSystemObject

Gets or sets whether the database is a system object.

public BooleanOption IsSystemObject { get; set; }

Property Value

BooleanOption

LastBackupDate

Gets or sets the date and time the database was last backed up. This only applies to on-premises installations of SQL Server.

public DateTime LastBackupDate { get; set; }

Property Value

DateTime

LastLogBackupDate

Gets or sets the date and time the database log was last backed up. This only applies to on-premises installations of SQL Server.

public DateTime LastLogBackupDate { get; set; }

Property Value

DateTime

MemoryAllocatedToMemoryOptimizedObjects

Gets or sets the memory allocated to memory optimized objects in MB. This applies to SQL Server 2014 and above.

public double MemoryAllocatedToMemoryOptimizedObjects { get; set; }

Property Value

double

MemoryUsedByMemoryOptimizedObjects

Gets or sets the memory used by memory optimized objects in MB. This applies to SQL Server 2014 and above.

public double MemoryUsedByMemoryOptimizedObjects { get; set; }

Property Value

double

Name

Gets or sets the name of the database.

public string Name { get; set; }

Property Value

string

Owner

Gets or sets the name of the owner of the database.

public string Owner { get; set; }

Property Value

string

Size

Gets or sets the size of the database in megabytes.

public double Size { get; set; }

Property Value

double

SpaceAvailable

Gets or sets the space available in the database in megabytes.

public double SpaceAvailable { get; set; }

Property Value

double

Status

Gets or sets the status of the database.

public SqlDatabaseStatus Status { get; set; }

Property Value

SqlDatabaseStatus

StatusString

Gets the status of the database.

public string StatusString { get; set; }

Property Value

string

Methods

FromXml(string)

Returns a CENTREL.XIA.Configuration.Types.SqlDatabaseGeneralSettings class from the specified XML.

public static SqlDatabaseGeneralSettings FromXml(string xml)

Parameters

xml string

The XML representation of the object.

Returns

SqlDatabaseGeneralSettings

A CENTREL.XIA.Configuration.Types.SqlDatabaseGeneralSettings class.