Interface ISQLWrapperStat

Inherited Members
Namespace: LemonEdge.API.Entities.Reporting
Assembly: LemonEdge.API.dll
Syntax
[EntityDefinition(EntityID.SQLWrapperStat, "dbo.LT_SQLWrapperStat", "SQLWrapperStat")]
[DefaultEntityIcon(ImageType.Statistics)]
[EntityIndex(Name = "SQLWrapper", ColumnNames = new string[] { "SQLWrapperID", "ExecutionStart", "ExecutionEnd" }, IndexOrder = new IndexOrder[] { IndexOrder.Ascending, IndexOrder.Ascending, IndexOrder.Ascending }, IsClustered = false)]
public interface ISQLWrapperStat : IBaseEntity, IEquatable<IBaseEntity>, INotifyPropertyChanged, INotifyPropertyChanging, ICloneableAsync, ICanTrackProperties

Properties

ExecutedAsCount

Indicates this execution was as a count only, and didn't return results

Declaration
[EntityProperty(SQLType.Bit, false)]
[EntityDescription("Indicates this execution was as a count only, and didn't return results")]
bool ExecutedAsCount { get; set; }
Property Value
Type Description
bool

ExecutionEnd

The end date/time the query was run from

Declaration
[EntityProperty(SQLType.DateTimeOffset, false)]
[EntityDescription("The end date/time the query was run from")]
DateTimeOffset ExecutionEnd { get; set; }
Property Value
Type Description
DateTimeOffset

ExecutionError

Any error caught from this execution

Declaration
[EntityProperty(SQLType.NVarChar, true)]
[EntityDescription("Any error caught from this execution")]
string ExecutionError { get; set; }
Property Value
Type Description
string

ExecutionSQL

The sql used to execute the sql wrapper

Declaration
[EntityProperty(SQLType.NVarChar, false)]
[EntityDescription("The sql used to execute the sql wrapper")]
string ExecutionSQL { get; set; }
Property Value
Type Description
string

ExecutionStart

The start date/time the query was run from

Declaration
[EntityProperty(SQLType.DateTimeOffset, false)]
[EntityDescription("The start date/time the query was run from")]
DateTimeOffset ExecutionStart { get; set; }
Property Value
Type Description
DateTimeOffset

ExecutionTimeInSeconds

The total execution time in seconds

Declaration
[EntityProperty(SQLType.Int, false)]
[EntityDescription("The total execution time in seconds")]
int ExecutionTimeInSeconds { get; set; }
Property Value
Type Description
int

Failed

Indicates this execution failed

Declaration
[EntityProperty(SQLType.Bit, false)]
[EntityDescription("Indicates this execution failed")]
bool Failed { get; set; }
Property Value
Type Description
bool

ResultRowCount

Returns the total number of rows in the result set

Declaration
[EntityProperty(SQLType.Int, false)]
[EntityDescription("Returns the total number of rows in the result set")]
int ResultRowCount { get; set; }
Property Value
Type Description
int

SQLWrapperID

[Key] Links to ISQLWrapper. The parent sql wrapper this belongs to.

Declaration
[EntityProperty(SQLType.UniqueIdentifier, false)]
[EntityKeyProperty]
[EntityRelationship(EntityID.SQLWrapper, "ID", SingleJoinType.One, "SQL Wrapper", "Statistics", DeleteWithRelationship = true, PartOfParentSet = false, LinkToItemInSet = false, InheritPermissions = true)]
Guid SQLWrapperID { get; set; }
Property Value
Type Description
Guid

Extension Methods