Search Results for

    Show / Hide Table of Contents

    Class SQLAssembly

    Inheritance
    object
    BaseEntity
    BaseEntityWithPermissions
    SQLAssembly
    Implements
    ISQLAssembly
    IBaseEntityWithPermissions
    ISetCopier
    IUserSpecific
    IHasVersion
    IShareAcrossAccounts
    IBaseEntity
    IEquatable<IBaseEntity>
    INotifyPropertyChanged
    INotifyPropertyChanging
    ICloneableAsync
    ICanTrackProperties
    ICloneableAsync<ISQLAssembly>
    IUserSpecificPublicToggle
    Inherited Members
    BaseEntityWithPermissions.IsLocked(object)
    BaseEntityWithPermissions.CanWriteItem(object, IEntityRetriever, IReadOnlyCache, Guid)
    BaseEntityWithPermissions.PreLoadPermissions<T>(IEnumerable<T>, IEntityRetriever, IReadOnlyCache, Guid)
    BaseEntityWithPermissions.CanDeleteItem(object, IEntityRetriever, IReadOnlyCache, Guid)
    BaseEntityWithPermissions.CanChangeItemPermissions(object, IEntityRetriever, IReadOnlyCache, Guid)
    BaseEntity.HISTORY_ENDROWUPDATE_COLNAME
    BaseEntity.HasTrackedPropertyChanged(string)
    BaseEntity.OriginalTrackedPropertyValue(string)
    BaseEntity.OriginalTrackedPropertyValue<T>(string)
    BaseEntity.ClearTrackedOriginalValues()
    BaseEntity.GetAllOriginalTrackedPropertyValues()
    BaseEntity.GetLabel(string)
    BaseEntity.SetLabel(string, string)
    BaseEntity.SetSilentLabel(string, string)
    BaseEntity.ResetChangedTrackedPropertiesToOriginalValues()
    BaseEntity.AddTrackedOriginalValue(string, object)
    BaseEntity.SnapshotProperties()
    BaseEntity.RestoreFromSnapshot(Dictionary<string, object>)
    BaseEntity.IsBasePropertyName(string)
    BaseEntity.IsBaseRelationshipID(string)
    BaseEntity.OnPropertyChanging(string)
    BaseEntity.OnPropertyChanged(string)
    BaseEntity.Equals(IBaseEntity)
    BaseEntity.GetHashCode()
    BaseEntity.Equals(object)
    BaseEntity.Clone(object)
    BaseEntity.CopyFromSource(object)
    BaseEntity.TrackChanges
    BaseEntity.ModifiedByUserID_Label
    BaseEntity.ModifiedByUserID_Label_Silent
    BaseEntity.CanvasID_Label
    BaseEntity.CanvasID_Label_Silent
    BaseEntity.AlgorithmStepID_Label
    BaseEntity.AlgorithmStepID_Label_Silent
    BaseEntity.SafeID_Label
    BaseEntity.SafeID_Label_Silent
    BaseEntity.AccountID
    BaseEntity.ID
    BaseEntity.LastUpdated
    BaseEntity.ModifiedByUserID
    BaseEntity.CanvasID
    BaseEntity.AlgorithmStepID
    BaseEntity.SafeID
    BaseEntity.PropertyChanged
    BaseEntity.PropertyChanging
    object.GetType()
    object.MemberwiseClone()
    object.Equals(object, object)
    object.ReferenceEquals(object, object)
    Namespace: LemonEdge.API.Entities.Reporting
    Assembly: LemonEdge.API.Entities.Auto.dll
    Syntax
    [DataContract]
    public class SQLAssembly : BaseEntityWithPermissions, ISQLAssembly, IBaseEntityWithPermissions, ISetCopier, IUserSpecific, IHasVersion, IShareAcrossAccounts, IBaseEntity, IEquatable<IBaseEntity>, INotifyPropertyChanged, INotifyPropertyChanging, ICloneableAsync, ICanTrackProperties, ICloneableAsync<ISQLAssembly>, IUserSpecificPublicToggle

    Constructors

    SQLAssembly()

    Declaration
    public SQLAssembly()

    Properties

    Assembly

    The actual clr sql assembly.

    Declaration
    public byte[] Assembly { get; set; }
    Property Value
    Type Description
    byte[]

    AssemblyName

    The unique name for this clr assembly

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

    Description

    The user friendly description for this clr sql assembly

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

    Enabled

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

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

    IsPublic

    Indicates if this entity is visible to all users (public), or just the current user (private).

    Directly maps to UserID property

    Declaration
    [NotMapped]
    public bool IsPublic { get; set; }
    Property Value
    Type Description
    bool

    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

    IsSystem

    Indicates this item is part of the core system. Any changes will be overwritten if the version number is lower than the provided version number and the item is also marked as a system item.

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

    UserID

    Links to IUser. Indicates if this entity record is private to just the specified user, or if it is public to everyone (holding null)

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

    UserID_Label

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

    UserID_Label_Silent

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

    Version

    Indicates the version number of this item. Changes will only be overwritten if the provided new item has a higer version number than this one.

    Declaration
    [Required]
    [DatabasePropertyValidation("MyItem.IsSystem", "var allUserTeams = await Cache.GetAllItems<LemonEdge.API.Entities.Administration.IUserTeam>(); (await Cache.GetAllItems<LemonEdge.API.Entities.Administration.ITeam>()).Any(x => allUserTeams.Where(ut => ut.UserID == User.ID).Select(ut => ut.TeamID).Contains(x.ID) && x.CanEditSystemItems)", "User is not authorized to modify system items.")]
    public short Version { get; set; }
    Property Value
    Type Description
    short

    Methods

    CopyFromEntity(IBaseEntity)

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

    CopyFromSource(ISQLAssembly)

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

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

    The source object to copy all values from.

    ToString()

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

    Implements

    ISQLAssembly
    IBaseEntityWithPermissions
    ISetCopier
    IUserSpecific
    IHasVersion
    IShareAcrossAccounts
    IBaseEntity
    IEquatable<T>
    INotifyPropertyChanged
    INotifyPropertyChanging
    ICloneableAsync
    ICanTrackProperties
    ICloneableAsync<T>
    IUserSpecificPublicToggle

    Extension Methods

    LinqExtensions.AsArray<T>(T)
    LinqExtensions.ToArrayOfOne<T>(T)
    LinqExtensions.ToListOfOne<T>(T)
    MiscExtensions.SetIfNotEqual<T, TP>(T, Expression<Func<T, TP>>, TP)
    WeakReferenceExtensions.WeakReference(object)
    SQLExtensions.ToSQLValue(object, bool)
    ReflectionExtensions.ClearEventInvocations(object, string)
    StringExtensions.ToCSVFormatString(object, Type)
    In this article
    Back to top © LemonEdge Technologies. All rights reserved.