Dynamcis CRM On Premise Console App

To create a console app that connects to Dynamics CRM 2015, we will use the CrmServiceClient.

Create a new Visual Studio project and add the assemblies:

• Microsoft.Crm.Sdk.Proxy
• Microsoft.Xrm.Sdk;
• Microsoft.Xrm.Tooling.Connector

In the code, add Using:

using Microsoft.Xrm.Tooling.Connector;
using Microsoft.Xrm.Sdk;
using Microsoft.Crm.Sdk.Messages;
using Microsoft.Xrm.Sdk.Query;

To connect to CRM, we will use the connection information to pass to CrmServiceClient:

  string userid = "Administrator";
 string password = "yourpassword";
 string domain = "YOURDOMAIN";
 string orgname = "CarlCo";
 string server = "localhost";
 string port = "5555";
 
 CrmServiceClient conn = new CrmServiceClient(new System.Net.NetworkCredential(userid, password, domain),server, port, orgname);

We can then use a QueryExpression to get data from CRM with the Organization Service:

 IOrganizationService _orgService;
 _orgService = (IOrganizationService)conn.OrganizationServiceProxy;

 QueryExpression query = new QueryExpression("contact");
 query.ColumnSet.AddColumns("firstname", "lastname");

 EntityCollection result1 = _orgService.RetrieveMultiple(query);
 foreach (var a in result1.Entities)
 {
    Console.WriteLine("Name: " + a.Attributes["firstname"] + " " + a.Attributes["lastname"]);
 }
 Console.Read();

Code can now be run:

Full code:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

using Microsoft.Xrm.Tooling.Connector;
using Microsoft.Xrm.Sdk;
using Microsoft.Crm.Sdk.Messages;
using Microsoft.Xrm.Sdk.Query;

namespace Carl.Crm.ConsoleApp
{
 class Program
 {
 static void Main(string[] args)
 {

 string userid = "Administrator";
 string password = "yourpassword";
 string domain = "YOURDOMAIN";
 string orgname = "CarlCo";
 string server = "localhost";
 string port = "5555";
 
 CrmServiceClient conn = new CrmServiceClient(new System.Net.NetworkCredential(userid, password, domain),server, port, orgname);

 IOrganizationService _orgService;
 _orgService = (IOrganizationService)conn.OrganizationServiceProxy;

 QueryExpression query = new QueryExpression("contact");
 query.ColumnSet.AddColumns("firstname", "lastname");

 EntityCollection result1 = _orgService.RetrieveMultiple(query);
 foreach (var a in result1.Entities)
 {
 Console.WriteLine("Name: " + a.Attributes["firstname"] + " " + a.Attributes["lastname"]);
 }
 Console.Read();
 }
 }
}

ABOUT CARL DE SOUZA

Carl de Souza is a developer and architect focusing on Microsoft Dynamics 365, Power BI, Azure, and AI.

carldesouza.com | LinkedIn | Twitter | YouTube

Facebook

Twitter

Linkedin