Connect to Microsoft Dynamics CRM 2013 online using C#

In this blog, I am going to explain how to create connection with Online Microsoft Dynamics CRM and how to fetch data of CRM using C#.

Fetch records from online crm entity using c#. First of all add required references and add few important namespaces :

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

Now, for creating connection with Online dynamics CRM 2013, add below code inside your class with your URL, UserName and Password of your Online Dynamics CRM .

OrganizationService _orgservice = new OrganizationService(CrmConnection.Parse("Url=https://YourURLname.crmX.dynamics.com; Username=user.name@YourSolName.onmicrosoft.com; Password=YourPassword;"));

Now, for retrieving records from your online CRM for any entity get the fetchXML by using AdvancedFind and use that fetchXML here for getting records. Here, in my example i am fetching records of Lead entity. ::

try
                {
string fetchXML = @"<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>
  <entity name='lead'>
    <attribute name='fullname' />
    <attribute name='companyname' />
    <attribute name='telephone1' />
    <attribute name='leadid' />
    <attribute name='statecode' />
    <order attribute='fullname' descending='false' />
    <filter type='and'>
      <condition attribute='statecode' operator='in'>
        <value>0</value>
        <value>1</value>
      </condition>
    </filter>
  </entity>
</fetch>";


                 EntityCollection result = _orgservice.RetrieveMultiple(new FetchExpression(fetchXML));
                foreach (var c in result.Entities)
                {
                    ListBox2.Items.Add(c.Attributes["fullname"].ToString());
                    Label2.Text = "Total records retrieved through fetchXml are: " + ListBox2.Items.Count.ToString();
                   // Console.WriteLine("Type of enquiry: {0} , Enquiry No.: {1}", c.Attributes["new_keytypeofenquiryid"].ToString(), c.Attributes["leadid"].ToString());
                }
                }
                catch (FaultException<Microsoft.Xrm.Sdk.OrganizationServiceFault>)
                {
                    throw;
                }
            catch (FaultException<Microsoft.Xrm.Sdk.OrganizationServiceFault>)
            {
                // You can handle an exception here or pass it back to the calling method.
                throw;
            }