Interface ISQLAssembly

The system entity for clr sql assemblies which can be used in IDataset and ISQLWrapper sql

See https://help.lemonedge.com/help/settings/enterprise-tools/sql-functions/intro.html for more information

See https://docs.microsoft.com/en-us/sql/relational-databases/clr-integration-database-objects-user-defined-functions/clr-user-defined-aggregate-invoking-functions?view=sql-server-ver15 for information about sql clr functions
Inherited Members
Namespace: LemonEdge.API.Entities.Reporting
Assembly: LemonEdge.API.dll
Syntax
[EntityDefinition(EntityID.SQLAssembly, "dbo.LT_SQLAssemblies", "SQLAssembly", IsStandingDataEntity = false, HelpURL = "help/settings/enterprise-tools/sql-functions/intro.html", LabelColumn = "AssemblyName")]
[DefaultEntityIcon(ImageType.DatabaseAdd)]
[EntityIndex(Name = "Name", ColumnNames = new string[] { "UserID", "AssemblyName" }, IndexOrder = new IndexOrder[] { IndexOrder.Ascending, IndexOrder.Ascending }, IncludeColumns = new string[] { "SafeID", "Version", "AlgorithmStepID" }, IsClustered = false, IsUnique = false)]
public interface ISQLAssembly : IBaseEntityWithPermissions, ISetCopier, IUserSpecific, IHasVersion, IShareAcrossAccounts, IBaseEntity, IEquatable<IBaseEntity>, INotifyPropertyChanged, INotifyPropertyChanging, ICloneableAsync, ICanTrackProperties

Properties

Assembly

The actual clr sql assembly.

Declaration
[EntityProperty(SQLType.VarBinary, false)]
[EntityDescription("The actual clr sql assembly.")]
byte[] Assembly { get; set; }
Property Value
Type Description
byte[]

AssemblyName

The unique name for this clr assembly

Declaration
[EntityProperty(SQLType.NVarChar, 500, false)]
[EntityDescription("The unique name for this clr assembly.")]
[Unique]
[Required]
[EntityKeyProperty]
string AssemblyName { get; set; }
Property Value
Type Description
string

Description

The user friendly description for this clr sql assembly

Declaration
[EntityProperty(SQLType.NVarChar, 2500, true)]
[EntityDescription("The user friendly description for this clr sql assembly.")]
string Description { get; set; }
Property Value
Type Description
string

Enabled

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

Declaration
[EntityProperty(SQLType.Bit, false)]
[EntityDescription("Indicates if this clr sql assembly is created and usable in the database.")]
[Required]
bool Enabled { get; set; }
Property Value
Type Description
bool

Extension Methods

See Also