AliasedValue Class

مقالة
11/28/2016

Applies To: Dynamics 365 (online), Dynamics 365 (on-premises), Dynamics CRM 2016, Dynamics CRM Online

Used to return aggregate, group by, and aliased values from a query.

Namespace: Microsoft.Xrm.Sdk
Assembly: Microsoft.Xrm.Sdk (in Microsoft.Xrm.Sdk.dll)

Inheritance Hierarchy

System.Object
Microsoft.Xrm.Sdk.AliasedValue

Syntax

[DataContractAttribute(Name = "AliasedValue", Namespace = "https://schemas.microsoft.com/xrm/2011/Contracts")]
[KnownTypeAttribute("GetKnownAliasedValueTypes")]
public sealed class AliasedValue : IExtensibleDataObject

<DataContractAttribute(Name := "AliasedValue", Namespace := "https://schemas.microsoft.com/xrm/2011/Contracts")>
<KnownTypeAttribute("GetKnownAliasedValueTypes")>
Public NotInheritable Class AliasedValue
    Implements IExtensibleDataObject

Constructors

	Name	Description
	AliasedValue()	Initializes a new instance of the AliasedValue class.
	AliasedValue(String, String, Object)	Initializes a new instance of the AliasedValue class.

Properties

	Name	Description
	AttributeLogicalName	Gets the name of the attribute on which the aggregate, group by, or select operation was performed.
	EntityLogicalName	Gets the name of the entity the attribute belongs to.
	ExtensionData	Gets or sets the structure that contains extra data.
	Value	Gets the value returned by the query.

Methods

	Name	Description
	Equals(Object)	(Inherited from Object.)
	GetHashCode()	(Inherited from Object.)
	GetType()	(Inherited from Object.)
	ToString()	(Inherited from Object.)

Examples

// Fetch the average of estimatedvalue for all opportunities.  This is the equivalent of 
                    // SELECT AVG(estimatedvalue) AS estimatedvalue_avg ... in SQL.
                    System.Console.WriteLine("===============================");
                    string estimatedvalue_avg = @" 
                    <fetch distinct='false' mapping='logical' aggregate='true'> 
                        <entity name='opportunity'> 
                           <attribute name='estimatedvalue' alias='estimatedvalue_avg' aggregate='avg' /> 
                        </entity> 
                    </fetch>";

                    EntityCollection estimatedvalue_avg_result = _serviceProxy.RetrieveMultiple(new FetchExpression(estimatedvalue_avg));

                    foreach (var c in estimatedvalue_avg_result.Entities)
                    {
                        decimal aggregate1 = ((Money)((AliasedValue)c["estimatedvalue_avg"]).Value).Value;
                        System.Console.WriteLine("Average estimated value: " + aggregate1);

                    }

Thread Safety

Any public static ( Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

مشاركة عبر