Edit

Sample: Create a LINQ query

  • Article

Download the complete sample from Sample: Query data using LINQ.

Note

This sample applies to both Dynamics 365 Customer Engagement (on-premises) and Dataverse.

Prerequisites

Internet connection is required to download the sample project and to restore the NuGet packages used in the sample project.

Requirements

To obtain a local copy of all samples and build them, follow these steps:

  1. Download or clone the Samples repo so that you have a local copy.
  2. (Optional) Edit the dataverse/App.config file to define a connection string specifying the instance/organization you want to connect to.
  3. Open the sample solution in Visual Studio and press F5 to run the sample. After you specify a connection string in dataverse/App.config, any sample you run will use that connection information.

If you don't specify a connection string in dataverse/App.config file, a dialog opens each time you run the sample, and you'll need to enter information about which instance or org you want to connect to and which credentials you want to use. This dialog caches previous connections so that you can choose a previously used connection.

Demonstrates

This sample shows how to create simple .NET Language-Integrated Query (LINQ) queries. The following queries are demonstrated:

  • Retrieve all accounts that the calling user has access to.

  • Retrieve all accounts owned by the user who has read access rights to the accounts and where the last name of the user is not “Cannon.”

  • Return a count of all accounts that have a county specified in their addresses.

  • Return a count of states in which we have an account. This uses the distinct keyword that counts a state only once.

  • Return contacts where the city equals “Redmond” AND the first name is “Joe” OR “John.”

Example

SampleProgram.cs

See also

Build Queries with LINQ (.NET Language-Integrated Query)
Sample: Complex LINQ Queries
OrganizationServiceContext