Table of Contents

Class SqlStoredProcedure

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

Represents a stored procedure for a SQL server database.

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

Constructors

SqlStoredProcedure()

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

public SqlStoredProcedure()

Properties

AnsiNullsStatus

Gets or sets the ANSI NULLs status for the stored procedure.

public BooleanOption AnsiNullsStatus { get; set; }

Property Value

BooleanOption

CreationScript

Gets or sets the SQL script used to create the stored procedure.

public SqlScript CreationScript { get; set; }

Property Value

SqlScript

DateCreated

Gets or sets the date and time the stored procedure was created.

public DateTime DateCreated { get; set; }

Property Value

DateTime

DateLastModified

Gets or sets the date and time the stored procedure was last modified.

public DateTime DateLastModified { get; set; }

Property Value

DateTime

Description

Gets or sets the description of the stored procedure.

public string Description { get; set; }

Property Value

string

ExecutionContext

Gets or sets the execution context for the stored procedure.

public SqlExecutionContext ExecutionContext { get; set; }

Property Value

SqlExecutionContext

ExecutionContextPrincipal

Gets or sets the user account for which to execute the code.

public string ExecutionContextPrincipal { get; set; }

Property Value

string

ExecutionContextString

Gets the execution context.

public string ExecutionContextString { get; set; }

Property Value

string

ExtendedProperties

Gets or sets the extended properties for the stored procedure.

public SqlExtendedProperties ExtendedProperties { get; set; }

Property Value

SqlExtendedProperties

ForReplication

Gets or sets whether the stored procedure is for replication.

public BooleanOption ForReplication { get; set; }

Property Value

BooleanOption

Identifier

Gets or sets the unique identifier for the stored procedure. This is for internal use only.

public Guid Identifier { get; set; }

Property Value

Guid

IsEncrypted

Gets or sets whether the stored procedure is encrypted.

public BooleanOption IsEncrypted { get; set; }

Property Value

BooleanOption

IsNativelyCompiled

Gets or sets whether the stored procedure is natively compiled. This applies to SQL Server 2014 and above.

public BooleanOption IsNativelyCompiled { get; set; }

Property Value

BooleanOption

IsSchemaBound

Gets or sets whether the stored procedure is schema bound.

public BooleanOption IsSchemaBound { get; set; }

Property Value

BooleanOption

IsSystemObject

Gets or sets whether the stored procedure is a system object.

public BooleanOption IsSystemObject { get; set; }

Property Value

BooleanOption

Name

Gets or sets the name of the stored procedure.

public string Name { get; set; }

Property Value

string

Owner

Gets or sets the owner of the stored procedure.

public string Owner { get; set; }

Property Value

string

Parameters

Gets or sets the parameters defined for the stored procedure.

public SqlStoredProcedureParameters Parameters { get; set; }

Property Value

SqlStoredProcedureParameters

QuotedIdentifierStatus

Gets or sets the quoted identifier status for the stored procedure.

public BooleanOption QuotedIdentifierStatus { get; set; }

Property Value

BooleanOption

Recompile

Gets or sets the recompile setting for the stored procedure.

public BooleanOption Recompile { get; set; }

Property Value

BooleanOption

Schema

Gets or sets the schema for the stored procedure.

public string Schema { get; set; }

Property Value

string

Methods

Clone()

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

public SqlStoredProcedure Clone()

Returns

SqlStoredProcedure

A CENTREL.XIA.Configuration.Types.SqlStoredProcedure.

CompareTo(SqlStoredProcedure)

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

public int CompareTo(SqlStoredProcedure other)

Parameters

other SqlStoredProcedure

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

Returns

int

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