Introduction
Start your Dynamics CRM operations from your ASP.NET application. In this article we will learn and look how to connect Dynamics CRM.
We need to download CRM SDK to connect CRM.
For more information you can refer to this link.
Download SDK
About SDK and Useful Libraries information
  1. using microsoft.crm.sdk.proxy.dll;
  3. using microsoft.xrm.sdk.dll;
  5. using microsoft.xrm.client.dll;
Conceptual Information
CRM SDK provides required essentials to make proper connection,
Define Data Connection
In this section, learn how to define Dynamics CRM Connection,
  1. OrganizationService service = new OrganizationService("YourCRMConnectionString");
Organization service is the data connection class,
  1. String YourCRMConnectionString = @"Url=http://Servername/yourworkCatalog; Domain=mydomain; Username=*******; Password=*****;"
Other values,
  1. service.Server = "Servername";
  2. service.user = "username";
  3. service.organization = "*****";
Simple format otherwise,
  1. <connectionStrings>
  2. <add name="Server=servername, organization=YourCatalogworks, user=****" connectionString="Url=http://myserver/AdventureWorksCycle; Domain=SalesLabs; Username=maruthi; Password=********;" />
  3. </ connectionStrings>
Get Sample Record
The following business logic helps you to get Sample Account Records,
  1. public List < SampleAccountEntryRecords > GetRecords()
  2. {
  3. using(OrganizationService service = new OrganizationService("YourCRMConnectionString"))
  4. {
  5. QueryExpression query = new QueryExpression
  6. {
  7. EntityName = "account",
  8. ColumnSet = new ColumnSet("accountid", "name", "revenue", "numberofemployees", "primarycontactid")
  9. };
  10. List < SampleAccountEntryRecords > info = new List < SampleAccountEntryRecords > ();
  11. EntityCollection accountRecord = service.RetrieveMultiple(query);
  12. }
  13. }
Sample Data Model
  1. public class SampleAccountEntryRecords
  2. {
  3. public Guid AccountID
  4. {
  5. get;
  6. set;
  7. }
  8. public string AccountName
  9. {
  10. get;
  11. set;
  12. }
  13. public int NumberOfEmployees
  14. {
  15. get;
  16. set;
  17. }
  18. public Money Revenue
  19. {
  20. get;
  21. set;
  22. }
  23. public EntityReference PrimaryContact
  24. {
  25. get;
  26. set;
  27. }
  28. public string PrimaryContactName
  29. {
  30. get;
  31. set;
  32. }
  33. public decimal RevenueValue
  34. {
  35. get;
  36. set;
  37. }
  38. }
The above snippets help us to get records from CRM.
References: For more information refer the link,
MVC Model Sample: MVC Model