Table of Contents

Class SqlUserDefinedFunction

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

Represents a user defined function for a SQL server database.

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

Constructors

SqlUserDefinedFunction()

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

public SqlUserDefinedFunction()

Properties

AnsiNullsStatus

Gets or sets the ANSI NULLs status for the user defined function.

public BooleanOption AnsiNullsStatus { get; set; }

Property Value

BooleanOption

CreationScript

Gets or sets the SQL script used to create the user defined function.

public SqlScript CreationScript { get; set; }

Property Value

SqlScript

DateCreated

Gets or sets the date and time the user defined function was created.

public DateTime DateCreated { get; set; }

Property Value

DateTime

DateLastModified

Gets or sets the date and time the user defined function was last modified.

public DateTime DateLastModified { get; set; }

Property Value

DateTime

Description

Gets or sets the description of the user defined function.

public string Description { get; set; }

Property Value

string

ExecutionContext

Gets or sets the execution context for the user defined function.

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 user defined function.

public SqlExtendedProperties ExtendedProperties { get; set; }

Property Value

SqlExtendedProperties

FunctionType

Gets or sets the function type.

public SqlUserDefinedFunctionType FunctionType { get; set; }

Property Value

SqlUserDefinedFunctionType

FunctionTypeString

Gets the function type as a human readable string.

public string FunctionTypeString { get; set; }

Property Value

string

Identifier

Gets or sets the unique identifier for the user defined function. This is for internal use only.

public Guid Identifier { get; set; }

Property Value

Guid

IsEncrypted

Gets or sets whether the user defined function is encrypted.

public BooleanOption IsEncrypted { get; set; }

Property Value

BooleanOption

IsNativelyCompiled

Gets or sets whether the user defined function is natively compiled. This applies to SQL Server 2016 and above.

public BooleanOption IsNativelyCompiled { get; set; }

Property Value

BooleanOption

IsSchemaBound

Gets or sets whether the user defined function is schema bound.

public BooleanOption IsSchemaBound { get; set; }

Property Value

BooleanOption

IsSystemObject

Gets or sets whether the user defined function is a system object.

public BooleanOption IsSystemObject { get; set; }

Property Value

BooleanOption

Name

Gets or sets the name of the user defined function.

public string Name { get; set; }

Property Value

string

Owner

Gets or sets the owner of the user defined function.

public string Owner { get; set; }

Property Value

string

Parameters

Gets or sets the parameters defined for the user defined function.

public SqlUserDefinedFunctionParameters Parameters { get; set; }

Property Value

SqlUserDefinedFunctionParameters

QuotedIdentifierStatus

Gets or sets the quoted identifier status for the user defined function.

public BooleanOption QuotedIdentifierStatus { get; set; }

Property Value

BooleanOption

Schema

Gets or sets the schema for the user defined function.

public string Schema { get; set; }

Property Value

string

Methods

Clone()

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

public SqlUserDefinedFunction Clone()

Returns

SqlUserDefinedFunction

A CENTREL.XIA.Configuration.Types.SqlUserDefinedFunction.

CompareTo(SqlUserDefinedFunction)

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

public int CompareTo(SqlUserDefinedFunction other)

Parameters

other SqlUserDefinedFunction

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

Returns

int

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