How to quickly connect to Dynamics CRM/365 (online-onprem) using C#?



Note: for this walkthrough I’ve been using ConsoleApplication


Step 1: Add following .Net references:
        System.Runtime.Serialization
      System.ServiceModel

Step 2: Add following references available in Bin folder of the SDK
        Microsoft.Xrm.Sdk
      Microsoft.Crm.Sdk.Portal
Step 3: Add following namespaces in your class file 
      using System.Runtime.Serialization;
      using System.ServiceModel;
      using System.ServiceModel.Description;
      using Microsoft.Xrm.Sdk;
      using Microsoft.Xrm.Sdk.Client;
      using Microsoft.Xrm.Sdk.Query;
      using Microsoft.Xrm.Sdk.Discovery;
      using Microsoft.Crm.Sdk.Messages;

Step 4: Create a method EstablishConnetionWithCRM with following three parameters:
       UserName - Provide O365 Userid in case of online CRM, for on-prem proivde doamin\username
       Password - Provide Password
      ServiceUrl - Provide Organization Service URL by going through following path in CRM
Microsoft Dynamics CRM > Settings > Customization > Developer Resources > Service Endpoints > Organization Service

Step 5: Your EstablishConnetionWithCRM method should look like following:
Public static void EstablishConnetionWithCRM(string UserName, string Password, string ServiceUrl){
try{
                ClientCredentials credentials = new ClientCredentials();
                credentials.UserName.UserName = UserName;
                credentials.UserName.Password = Password;
                Uri serviceUri = new Uri(ServiceUrl);
                OrganizationServiceProxy sp = new OrganizationServiceProxy(serviceUri, null, credentials, null);
                sp.EnableProxyTypes();
                _service = (IOrganizationService)sp;

            }
            catch (Exception ex)
            {

                Console.WriteLine("Error: " + ex.Message);
            }
}

Step 6: Call EstablishConnetionWithCRM into the Main method and check if you are connected or not:
static void Main(string[] args)
        {
            EstablishConnetionWithCRM ("<USERNAME>", "<PASSWORD>", "https://<DOMAIN>/XRMServices/2011/Organization.svc");
            Guid userId = ((WhoAmIResponse)_service.Execute(new WhoAmIRequest())).UserId;
            if (userId != Guid.Empty)
                Console.WriteLine("Connection Established Successfully");
              Else
                Console.WriteLine("Connection was not Established");

            Console.ReadLine();
        }


Final code will be following

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Runtime.Serialization;
using System.ServiceModel;
using System.ServiceModel.Description;

using Microsoft.Xrm.Sdk;
using Microsoft.Xrm.Sdk.Client;
using Microsoft.Xrm.Sdk.Query;
using Microsoft.Xrm.Sdk.Discovery;
using Microsoft.Crm.Sdk.Messages;

namespace connecToCRM
{
    class Program
    {
        static IOrganizationService _service;
        static void Main(string[] args)
        {
            EstablishConnetionWithCRM ("<USERNAME>", "<PASSWORD>", "https://<DOMAIN>/XRMServices/2011/Organization.svc");
            Guid userId = ((WhoAmIResponse)_service.Execute(new WhoAmIRequest())).UserId;
            if (userId != Guid.Empty)
                Console.WriteLine("Connection Established Successfully");
              Else
                Console.WriteLine("Connection was not Established");

            Console.ReadLine();
        } //End of Main

        Public static void EstablishConnetionWithCRM(string UserName, string Password, string ServiceUrl){
try{
                ClientCredentials credentials = new ClientCredentials();
                credentials.UserName.UserName = UserName;
                credentials.UserName.Password = Password;
                Uri serviceUri = new Uri(ServiceUrl);
                OrganizationServiceProxy sp = new OrganizationServiceProxy(serviceUri, null, credentials, null);
                sp.EnableProxyTypes();
                _service = (IOrganizationService)sp;

            }
            catch (Exception ex)
            {

                Console.WriteLine("Error: " + ex.Message);
            }
}//End of EstablishConnetionWithCRM function
    } //End of Class
}//End of namespace

~~YOU ARE DONE, ENJOY~~



Comments

Post a Comment

Popular posts from this blog

How to hide '+' on a subgrid in dynamics CRM?

I’ve to hide ‘+’ button of Order subgrid on Account form, because we are not allowing accounts to directly create Orders. Pre-requisite: Install latest version RibbonWorkBench tool from here  Create a Solutions, OrderRibbonSolution Add existing Entity, Order Publish the customization Launch RibbonWorkBench (RWB), Open the solution OrderRibbonSolution in RWB     4.    Create a new Enable rule and set following properties            a.    Default : False            b.    InvertRule : True            c.    EntityName : account            d.    Context : Form            e.    AppliesTo : PrimaryEntity     5....
Read more

Pick and Removing Can't be processed at the same time. To pick this queue item, please unselect the option for removal.

Image
Scenario At my work, I was assigned a task to automatically route the case to a queue member who is currently assigned fewer cases.  Development was completed and after detailed unit testing, it was released to UAT for QA to execute their test cases. It worked absolutely fine on the first day of QA. But, stopped working all of sudden. Problem Statement The cases stopped routing automatically to the queue member.  Also, when manually picking the queue item from the queue and selecting remove from the queue to YES, the below error was popping up. Solution So after spending hours on the internet to find out the reason behind it. We couldn't find any solution. However,  while doing a comparison between queues available in DEV and UAT, we find out that someone enabled "Automatic Work Distribution" (AWD) in queues available at UAT. Which is specifically for Omni Channel and that was stopping to remove the queue item as soon as it is picked up by someone. So as soon as we disabl...
Read more

Get Rid off Pending Email Warning - Microsoft Dynamics CRM

Image
Problem This is really weird when you login into MSD CRM and you came across with following screen. Reason This happen when you are sending email using workflow and the email stuck with status Pending Send Resolutions Following are three resolutions to this issue: Go to Settings > Email Configurations > Mail Boxes  and open Mail box ( that don't have approved email address and didn't test run ), then from Ribbon,   Approve Email Address and after that click on Test Run , You will see prompt coming from CRM, check the box click Ok . Create an on-demand workflow, to change the status of Pending Send email messages to some other status, say Canceled. And run this workflow from advanced find against those emails that are set to Pending Send Go to Advanced Find , Look For Email Message and Query for Status Reason  equals Pending Send, click Results and then delete all message with Pending Send Status After following any aforementioned step yo...
Read more