Class SQLFunction

Inheritance
object
BaseEntity
SQLFunction
Implements
Inherited Members
Namespace: LemonEdge.API.Entities.Reporting
Assembly: LemonEdge.API.Entities.Auto.dll
Syntax
[DataContract]
public class SQLFunction : BaseEntity, ISQLFunction, IShareAcrossAccounts, IBaseEntity, IEquatable<IBaseEntity>, INotifyPropertyChanged, INotifyPropertyChanging, ICloneableAsync, ICanTrackProperties, ICloneableAsync<ISQLFunction>

Constructors

SQLFunction()

Declaration
public SQLFunction()

Properties

CreateSQL

The sql signature for creating this function

Declaration
[Required]
[PropertyValidation("!string.IsNullOrEmpty(MyItem.CreateSQL)", "!MyItem.CreateSQL.ContainsWholeWord(\"go\", StringComparison.InvariantCultureIgnoreCase) && !MyItem.CreateSQL.ContainsWholeWord(\"drop\", StringComparison.InvariantCultureIgnoreCase, new string[] { \"drop table #\" }) && !MyItem.CreateSQL.ContainsWholeWord(\"create\", StringComparison.InvariantCultureIgnoreCase, new string[] { \"create table #\" }) && !MyItem.CreateSQL.ContainsWholeWord(\"exec\", StringComparison.InvariantCultureIgnoreCase)", "Contains invalid sql.")]
[StringLength(500)]
public string CreateSQL { get; set; }
Property Value
Type Description
string

Description

The user friendly description for this clr sql function

Declaration
[StringLength(2500)]
public string Description { get; set; }
Property Value
Type Description
string

Enabled

Indicates if this clr sql function is created and usable in the database.

Declaration
[Required]
public bool Enabled { get; set; }
Property Value
Type Description
bool

ExternalName

The external name for this sql clr function

Declaration
[Required]
[StringLength(500)]
public string ExternalName { get; set; }
Property Value
Type Description
string

IsShared

Indicates this record is a shared record. Only the root account can edit items that are shared records

Declaration
public bool IsShared { get; set; }
Property Value
Type Description
bool

Name

The unique user friendly name of this clr sql function

Declaration
[Unique]
[Required]
[StringLength(500)]
public string Name { get; set; }
Property Value
Type Description
string

SQLAssemblyID

Declaration
public Guid SQLAssemblyID { get; set; }
Property Value
Type Description
Guid

SQLAssemblyID_Label

Declaration
public string SQLAssemblyID_Label { get; set; }
Property Value
Type Description
string

SQLAssemblyID_Label_Silent

Declaration
[NotMapped]
public string SQLAssemblyID_Label_Silent { get; set; }
Property Value
Type Description
string

Type

The type of this clr sql function

Declaration
[EnumDataType(typeof(SQLFunctionType))]
public SQLFunctionType Type { get; set; }
Property Value
Type Description
SQLFunctionType

Type_Tooltip

Declaration
[NotMapped]
public string Type_Tooltip { get; set; }
Property Value
Type Description
string

Methods

CopyFromEntity(IBaseEntity)

Declaration
protected override void CopyFromEntity(IBaseEntity src)
Parameters
Type Name Description
IBaseEntity src
Overrides

CopyFromSource(ISQLFunction)

Updates all properties in this item to have the same properties as the source object.

Declaration
public void CopyFromSource(ISQLFunction source)
Parameters
Type Name Description
ISQLFunction source

The source object to copy all values from.

ToString()

Declaration
public override string ToString()
Returns
Type Description
string
Overrides

Implements

Extension Methods