Order results using entity attributes with LINQ
Dynamics CRM 2016
Updated: November 29, 2016
Applies To: Dynamics 365 (online), Dynamics 365 (on-premises), Dynamics CRM 2016, Dynamics CRM Online
In Microsoft Dynamics 365 and Microsoft Dynamics 365 (online), you can use lookup or OptionSet (Picklist) attributes to order results within a LINQ query. This topic shows several examples of this type of query.
The following sample shows use the lookup attribute PrimaryContactId in an Order By clause.
using (ServiceContext svcContext = new ServiceContext(_serviceProxy)) { var query_orderbylookup = from a in svcContext.AccountSet where a.Address1_Name == "Contoso Pharmaceuticals" orderby a.PrimaryContactId select new { a.Name, a.Address1_City }; foreach (var a in query_orderbylookup) { System.Console.WriteLine(a.Name + " " + a.Address1_City); } }
The following sample shows use of a lookup value to order by.
using (ServiceContext svcContext = new ServiceContext(_serviceProxy)) { var query_orderbypicklist = from c in svcContext.ContactSet where c.LastName != "Parker" && c.AccountRoleCode != null orderby c.AccountRoleCode, c.FirstName select new { AccountRole = c.FormattedValues["accountrolecode"], c.FirstName, c.LastName }; foreach (var c in query_orderbypicklist) { System.Console.WriteLine(c.AccountRole + " " + c.FirstName + " " + c.LastName); } }
Microsoft Dynamics 365
© 2016 Microsoft. All rights reserved. Copyright
Community Additions
ADD
Show: